Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have an expression derived from other 4 expressions in a straight table. I want to use only this derived expression in a pivot table.
Is there a way to copy this expression over in the new pivot table?
I was searching for 2 options:1) copy all those base expressions and hide them (but not sure how to hide them and still be able to use their values in this derived expression.
2) a way to copy only this derived expression from the Straight table.
Thanks a bucnh for your time and help.
No way to hide expressions in pivot table (if you use the condition box the column's value is not accessible).
No way to use the derived expression (you can copy it but obviously other values are in the other table)
I think you cannot follow this way ...
create an expression by mixing all the other and copy it in the new table
Two options:
1. Copy the expressions one by one from the straight table to the pivot table;
2. Clone the straight table and change the chart type of the cloned copy to a pivot table, this may require you to change to the dimensions if they are not the same.
Either way you cannot hide expression in a pivot table.
Copying is tough to do because i have 3 expressions , 1 derived from these 3 and 5th one (which i need to use in other table) is derived from all the other 4 expressions.
Hi Colin,
Thats exactly what I have done now, but that still doesnt help to get rid of the expressions i dont want to include.
So looks like there is no way to do either of the two options ?
any other method to conditionally hide a column from the pivot table?
Yes you can try conditional check box. Just make sure you have at least one always enabled.
Can you help me with the specific condition that I need to write in order to hide the column?
Thanks
Well it can be many things dependent on your requirements. try to have it result in a binary 1=true / false 0
If(condition is true, 1,0 )
Wildmatch(String,'1','2','3') > 0
Hi Brian,
I am sorry I still dont follow, I understand we would want to specify bolean values.
But what would be a If(condition is true, 1,0 ) in this case that Qlikview will interpret that "should hide" the expressions correctly?
Correct. Within the if statement you may have criteria to determine selections are made, etc to check against if they are met, then it results in a 1 for enabled. Or may be a simple Count(Sales) > 1000 which would result in a true false and allow expression. Endless possibilities. I cant write it unless I know what they are.