Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,I need your help..
I've created a pivot table.
The table have dimension "KPI name" that's have a number as key.
Also have "company name" as the dimension.
The expression is matched by the KPI key.
this is the table:
it is empty, as you can see..
when I'm choosing a KPI like this:
the table is fine, but only show what i chose:
but when i'm not choosing the table is empty
in the expression, when i write: CalYear it's works but it puts only the string as it is: sum(PRR_Qty)
when im write: $(=CalYear ) its working only when im choosing KPI 😕
why this is happening? your help is appreciated. thank you and have a nice day.
Can you post a small qlikview document that shows what you're trying to do?