Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
deepikavijayan
Partner - Contributor
Partner - 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

0 Replies