Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

mazacini
Not applicable

Count and Rank table chart by 2 expressions: current and YTD

I have a straight Table chart with expressions for Current Month Sales (as selected) and YTD Sales (using SET Analysis).

Dimension is Customer.

I want to introduce columns based on Rank and Count.

Some YTD Customers will have no activity in Cuurent Month.

How can I exclude these from the Rank and Count calculations for Current Month?

1 Reply
goldnejea8
Not applicable

Re: Count and Rank table chart by 2 expressions: current and YTD

How about something like this?

sum( {$<Customer = {“=Sum({1<Month=>} Sales ) > 0”}>} Sales )