Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

Issue with Pivot table in Qlik Sense

Hi All,

I am building a pivot table in Qliksense for zonewise number of registrations and target registrations for a bank. In dimensions, I have a zone column and a date column. For measure, I have new number of registrations. So the data shown is new registrations per day per zone. 

My client is basically interested in the total column that comes up at the beginning. So it shows sum of zone wise registrations for all the dates, depicted in image 1.

Now the new metric that I want to add is, target registrations which is calculated as:
5*count(distinct branch_id)

As the grain of both the metric calculations is not same, I get the same target for all dates and the total column which is not correct(illustrated in image 2).
My client is only interested in the totals section and does not want to see the individual day wise target(as the value is wrong). This is illustrated in image 3. For this, I removed the 2nd expression and tried adding it as a calculated dimension but it did not work.

Can someone help in meeting this requirement?

Thanks

Labels (1)
2 Replies
Highlighted
Specialist III
Specialist III

Re: Issue with Pivot table in Qlik Sense

I'm fairly sure you were headed in the right direction when you tried creating a calculated dimension, but you probably need to wrap it in an AGGR() to make it work:

5*Aggr(count(distinct branch_id),Zone)

 

Highlighted
Creator
Creator

Re: Issue with Pivot table in Qlik Sense

Hello,

I think you can work this out with the content from this post:

https://community.qlik.com/t5/New-to-QlikView/Pivot-table-Hide-measure-column-based-on-dimension-val...

I have never tried but it appears to be somewhat similar.