Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Pivot table problem

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.

KPI_IDKPI Name
1PPM Arkal
2CPM Arkal
KPI_IDCalYear
1Sum(PRR_Qty)*1000000 / Sum(Sales_Qty)
2sum(PRR_Qty)

this is the table:

1.PNG

it is empty, as you can see..

when I'm choosing a KPI like this:

2.PNG

the table is fine, but only show what i chose:

3.PNG

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.

1 Reply
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

Can you post a small qlikview document that shows what you're trying to do?


talk is cheap, supply exceeds demand