topic Using pivot table to show exact values in App Development

Using pivot table to show exact values

drey90 — Mon, 20 Dec 2021 21:38:40 GMT

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 file

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

When it collapsed, it show different values.

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

Please advise. Thanks.

y_grynechko — Mon, 10 Feb 2020 16:01:39 GMT

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 — Tue, 11 Feb 2020 02:11:39 GMT

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 — Tue, 11 Feb 2020 20:04:43 GMT

Yes, dimensionality can be used in qlik sense: