-
Re: Expression with condition on a list
Michele De Nardi Nov 27, 2017 3:15 AM (in response to Naoual EL RHAFFOULI)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
Naoual EL RHAFFOULI Nov 27, 2017 3:38 AM (in response to Michele De Nardi)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
Antonio Mancini Nov 27, 2017 3:19 AM (in response to Naoual EL RHAFFOULI)Try this
sum({<Flag={‘Y’}>} [Nb of Cases])
-
Re: Expression with condition on a list
Naoual EL RHAFFOULI Nov 27, 2017 3:40 AM (in response to Antonio Mancini)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
Michele De Nardi Nov 27, 2017 3:45 AM (in response to Naoual EL RHAFFOULI)Can yuo share some sample data and the expected result ?
-
Re: Expression with condition on a list
Naoual EL RHAFFOULI Nov 27, 2017 3:57 AM (in response to Michele De Nardi)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
Michele De Nardi Nov 27, 2017 4:04 AM (in response to Naoual EL RHAFFOULI)Can you share some sample data in excel format or directly the .qvf ?
-
Re: Expression with condition on a list
Naoual EL RHAFFOULI Nov 27, 2017 4:12 AM (in response to Michele De Nardi)
-
-
-
-
-