Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a pivot table in QlikView and would only like to show the information for Client ID's that have an amount in any of the expressions over 2,000.
In this case, I don't care about client 7564 and the one row for client 6633 and don't want them to be shown at all.
You'd need something like:
If(Max(Aggr(Sum(Sales),[Client ID],[Date],[Sold Deal Date]))>2000,Sum(Sales))
I can't check this without sample data, which I am not able to generate at the moment and was not included in the post, but even if it's not precisely what you need it will hopefully nudge you in the right direction.
You'd need something like:
If(Max(Aggr(Sum(Sales),[Client ID],[Date],[Sold Deal Date]))>2000,Sum(Sales))
I can't check this without sample data, which I am not able to generate at the moment and was not included in the post, but even if it's not precisely what you need it will hopefully nudge you in the right direction.