Qlik Community

Ask a Question

App Development

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

Announcements
Join us for a live Q&A! September 21, 10 AM ET - Onboarding Fast in Qlik Sense SaaS! REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
mansi_dv
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
Or
Master
Master

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)

 

Gui_Approbato
Creator III
Creator III

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.