Discussion Board for collaboration on QlikView Scripting.
Dear Qlikview Experts.
I would like to do something like this;
SET Var1 = Col1;
SET Var2 = Col2;
Let us say for example the result of Var1 = 1000 and Var 2 = 2000.
Then Create a table like this:
Then I would like to do some pivot table calculation based on this table like this:
I want to see the following result.
I am attaching a file here. As you can see I can get the pivot1 derived from Table3 in the script working. But Pivot2 derived from Table4 is not working.
Can someone help me achieve this?
Thank you very much in advance.
Use this expression: =NumberCol + Pick(match(VarCol,'Col1','Col2'),Col1,Col2)
Fantastic. That works. Thank you very much Gysbert. I have attached the solution.
let Var1 =1000;
LET Var2 =2000;
load Number+VarCol as New,
10 , $(Var1)
20 , $(Var2)
30 , $(Var1)
40 , $(Var2)