-
Re: Expression with condition on a list
You have forgot the dimension that P() function has to returns.
So, your set analysis could be something like:
sum({$<[Central Account #]=P({1<Flag={‘Y’}>}[Central Account #])>} [Nb of Cases])
If you need other information on how to use P() or E() check the below links:
P() & E() and where do you use them?
Set Analysis: syntaxes, examples
QlikView | Set Analysis | p(), e() and other aggregation function - YouTube
-
Re: Expression with condition on a list
Thank you Michel for your answer,
I used your correction, but it's still showing 0 :-/
I really don't know what went wrong
-
-
-
Re: Expression with condition on a list
Thank you Antonio,
This is actually what I used before using this expression sum({$<[Central Account #]=P({1<Flag={‘Y’}>})>} [Nb of Cases])
But it was showing the total number of cases, like it was not taking into account my condition
-
-
Re: Expression with condition on a list
Sure,
so basically, here is my flag in the data load editor
If([Next 1A Contract End]>=Date(Now()) and [Next 1A Contract End]<=Date(Now()+180),'Y','N') AS Flag,
basically it shows this dashboard
so my objective is to display the number of calls generated by the number displayed 564 accounts.
is that clarifying a bit?
Thanks
-
Re: Expression with condition on a list
Can you share some sample data in excel format or directly the .qvf ?
-
Re: Expression with condition on a list
here you go
I couldn't attach the excel, this is basically a sample of list of account, and I want the number of calls for those accounts only
Do you need me to attach something else?
Thanks
-
-
-
-
-
