Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
warrentk80
Creator
Creator

Comparing fields in SetAnalysis

Good morning
where to use the expression in a Setanalysis should make a comparison between two fields
I'll explain the formula that I wrote
if the second operator specific month the formula works

Sum ({1 <[MeseSerie] = {'January'}>} [Sales]) / 1000000
but if I have a field Meseselezione not know how to put it in the second operator I tried with:
Sum ({1 <[MeseSerie] = {[Meseselezione]}>} [Sales]) / 1000000


but it does not work 😞


thanks


Andrea

2 Replies
sunny_talwar

May be something like this:

Sum({1}Aggr(If(MeseSerie = Meseselezione, Sales), MeseSerie, Meseselezione))

MK_QSL
MVP
MVP

May be something like below

=SUM({<Customer = {"=MeseSerie = Meseselezione"}, MeseSerie  = {'Jan'}>}Sales)/1000000

Change Customer to YourFieldName