Boris Tyukin boristyukin
boristyukin
/ qlikview_set_expression_to_ignore_dimension_selections
Last active
January 1, 2016 18:19
Qlikview - dynamic set expression to disregard all calendar (or any other dimension) selections
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // Credit to http://community.qlikview.com/blogs/qlikviewdesignblog/2013/11/18/dollar-expansions | |
| // define variable which will pull/contatenate all members of dimension to disregard | |
| Set vClearCalendar = "='[' & Concat({1<$Table={'Calendar'}>} $Field, ']=,[') & ']=' "; | |
| // if you want to exclude some, for example Year: | |
| Set vClearCalendar = "='[' & Concat({1<$Table={'Calendar'}, $Field-={'Year'}>} $Field, ']=,[') & ']=' "; | |
| //this is how set expression will look like | |
| // Sum ({$<$(vClearCalendar)>} Amount) |
boristyukin
/ qlikview_dynamic_charts
Last active
August 29, 2015 14:15
QlikView implementation of dynamic charts (trends), driven by user selection
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Dimension Expression (Primary and Secondary) | |
| ------------------------------------------------ | |
| = $(='['&only(%TrendDimensionName)&']') | |
| = $(='['&only(%TrendDimensionNameSecondary)&']') | |
| Dimension Label | |
| ------------------------------------------------ | |
| =%TrendDimensionName | |
| Metric Expression |
boristyukin
/ ssis_output_value_from_script.cs
Last active
September 21, 2021 21:38
SSIS write string value to Output Window for debug
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /////////////////////////////////////// | |
| // For Script Task (control flow) | |
| /////////////////////////////////////// | |
| bool fireAgain = true; Dts.Events.FireInformation(1,"YOUR TITLE",myVar.ToString(),"",0, ref fireAgain); //debug message | |
| Dts.Events.FireError(0, "Error!", "Your custom Error message", String.Empty, 0); //raise custom error | |
| /////////////////////////////////////// | |
| //For Script Component (data flow) | |
| /////////////////////////////////////// |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| import org.apache.kudu.ColumnSchema | |
| import org.apache.kudu.Schema | |
| import org.apache.kudu.Type | |
| import org.apache.kudu.client.AlterTableOptions | |
| import org.apache.kudu.client.CreateTableOptions | |
| import org.apache.kudu.client.Insert | |
| import org.apache.kudu.client.KuduClient | |
| import org.apache.kudu.client.KuduException | |
| import org.apache.kudu.client.KuduPredicate | |
| import org.apache.kudu.client.KuduPredicate.ComparisonOp |
boristyukin
/ impala_command_drop_database_tables.sh
Created
March 23, 2019 01:41
How to drop all Impala tables in a given database
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| impala-shell -d mydbname -q 'show tables' -B | xargs -I '{}' impala-shell -d mydbname -q 'DROP TABLE IF EXISTS `{}`;' |