Qlik Community

Qlik Sense App Development

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

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
deepikavijayan
New Contributor

How to achieve Amount and Count format Pattern on same chart

Hi,


I'm using an variable which as Count/Amount options, On click of count the data of the chart should be displayed in number format and on click of amount the data should be displayed in money format,based on number of digits the money format should change to cr(crore),l(lakh),..automatically ,  but the format pattern does not change accordingly.

Below is the expression used in the chart:

sum(if(vRF='C',RFCount,

if(vRF='A',RFValue)))

vRF is the variable name used for selection of amount or count option, C-Count and A-Amount.

For reference Pfa .qvf file

Thanks and Regards,

Deepika

Community Browser