Qlik Community

App Development

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

Announcements
Coming Aug. 9: New Simplified Authoring for Qlik Sense SaaS – For Details, CLICK HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
drey90
Contributor II
Contributor II

Using pivot table to show exact values

Hi,

I have a problem here. My user has requested to show the exact value in the pivot table on how to populate in the data file. 

For example, below is the snapshot of how the data is populated in the data fileIM_Tree_Data File.JPG

 

 

In QlikSense, when the pivot table expanded, it show the correct value.IM_Tree_QS_View_Expand.jpg

 

 

 

 

 

When it collapsed, it show different values. 

IM_Tree_QS_View_Collapse.jpg

How do it show the correct value (-21,116,464) even if the pivot table collapsed? 

Please advise. Thanks. 

3 Replies
y_grynechko
Creator III
Creator III

Hey,

When you collapse it show the total that rolls under RatesFX. Which is: " " plus "FX" plus "IR".

To show something else than total in the top dimension you can use if(Dimensionality() = 1, do something, do something else).

If you share some data I can help you build the right measure. 

drey90
Contributor II
Contributor II
Author

Hi, 

Is the above formula applicable to Sense because I am using Sense to do app? 

Sorry that I cannot share data with you as it contain customer information. 

y_grynechko
Creator III
Creator III