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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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