Hi Qlikview Experts,
I have a straight table with the calculated dimension of:
=Aggr(FirstSortedValue({<LogType={2}>}[process status],-communicationQueueLogId),CommunicationQueueId)
And an expression of:
COUNT({<LogType={2}>}DISTINCT CommunicationQueueId)
This straight table works as expected with the correct results. I would like to add a filter after that expression has been calculated.
So, the calculated dimension and expression must evaluate to a certain result, and then after that has been evaluated, apply a certain filter.I have tried the obvious things like adding that condition in my set analysis or as a filter but the results are incorrect.
Is this possible? I want to add where [process status]='Done'
Thanks,
Yuvir
