Qlik Sense Line Chart requirement.

[AsifS]

Hi ,

I all I am pretty new to the Qlik Sense! Need your help!

I have a line Chart with Quarter on the X-Axis and around 10 Metrics . Now among these 10 metrics 5 show dollar value and 5 show percent. The requirement is to allow user see Percent Metrics at one time and the Dollar metrics at the other time based on filter. The filter will be having two values Precent and Dollar. 

I have inserted the photos for your reference:

Thanks in Advance!

[PrashantSangle]

modify your expression. add below condition
for Doller measure
Sum({<filter={"Doller"}>} Sales)

for Percentage measure
Sum({<filter={"Percent"}>} Sales)

Regards,
Prashant Sangle

[Channa]

try to create variable

if(variable=1,Sum({<filter={"Percent"}>} Sales),Sum({<filter={"Number"}>} Sales))

it should be ur measure 

in variable u pass 1 

[AsifS]

Thank You! But since I am very new to qlik would you please explain it with my attached use case !

[Channa]

step 1 LOAD * INLINE [

Filter

'Doller'
'Percentage'
];

step 2

createvariable vFilter =Filter

step 3 ur expression

=if(vfilter='Percentage',Sum({<DBCOLUMN={"Percent"}>} Sales),Sum({<DBCOLUMN={"Doller"}>} Sales))