Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Qlik experts!
I need your help!
I have the calculation of [Volume] based on selection in [Date] field as this one:
sum({<[Date]={">=$(=yearstart(max([Date]))) <=$(=max([Date]))"} > } [Volume])
But now I need to calculate the count of distinct customers which have the volume above.
I tried something like this:
count({<[Customer ID] = {"= sum({<[Date]={">=$(=yearstart(max([Date]))) <=$(=max([Date]))"} > } [Volume]) > 0"}>} distinct [Customer ID])
But it doesn't work. Also I tried to use variable for calculation the sum of volume and to use it the count calculation, but it was also without success.
Could anybody help me, how to implement this calculation?
Can you please explain me this code i wanna learn 🙂