Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
gauthamchilled
Creator
Creator

Ignoring dimension for one expression and including for other

I have dimension like this =Aggr([CustomerName],ProfitID)

and I have two expression 1 is sum(sales) and

2nd is sum({<{ Period='$(=max(Period)-1)'}>} Sales)

My requirement is i want to use =Aggr([CustomerName],ProfitID) dim for 1st expression and for second expression

i want to use just CustomerName

how can i do this?

Thanks

Gautham

10 Replies
sunny_talwar

Or just this?

If(Column(1) > 0, Sum({<Period={'2016'}>} Sales))

Capture.PNG