Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Creator
Creator

Set analysis in Combo Charts

I want to make a combo chart of Primary axis-'NetSalesUSD' as bars and secondary axis-average of the 'Discount%' as markers only for the entries "LRM" in the field 'LRM-MVS' across Regions(Dimension).

The set analysis function I used in the expression for measure is as follows:

=If([LRM-MVS]='LRM' ,[Discount%])

However, this is not functioning and does not take into acount that I need average od the discount %. Could someone help me with this code?

1 Solution

Accepted Solutions

May be you need this?

Avg({<[LRM-MVS] = {'LRM'}>} [Discount%])

View solution in original post

1 Reply

May be you need this?

Avg({<[LRM-MVS] = {'LRM'}>} [Discount%])

View solution in original post