Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

mhapanka
New Contributor III

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?

Tags (1)
1 Solution

Accepted Solutions

Re: Set analysis in Combo Charts

May be you need this?

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

1 Reply

Re: Set analysis in Combo Charts

May be you need this?

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

Community Browser