Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Hello,
I have these two expressions.
The first expression allows me to calculate the "Notified closed" status of the previous 3 years:
=count({$<echeance_date_YYYY={"<$(=year(today()))"},[Notifié cloturée/Non cloturée]={"Notifié cloturée"}>}DISTINCT key_nb_poste_commande)
The second expression allows me to calculate the status "Notified not closed for the next 3 years" :
=count({$<echeance_date_YYYY={">=$(=year(today()))"},[Notifié cloturée/Non cloturée]={"Notifié non cloturée"}>}DISTINCT key_nb_poste_commande)
I want to combine these 2 expressions in a single expression in order to have this result in my table:
Thanks 🙂
you can use or condition in set analysis
=count({$<echeance_date_YYYY={"<$(=year(today()))"},[Notifié cloturée/Non cloturée]={"Notifié cloturée"}>}
+ <echeance_date_YYYY={"<$(=year(today()))"},[Notifié cloturée/Non cloturée]={"Notifié non cloturée"}>}
DISTINCT key_nb_poste_commande)
refer links:
https://community.qlik.com/t5/QlikView-App-Dev/quot-OR-quot-Condition-in-Set-Analysis/td-p/695709
thanks
Vikas
1) Use a Pivot Table
2) Add Both Measures
3) Add dimension "echeance_date_YYYY" to the column section
4) Drag "Values" from Measure Section to Column Section (above Year)
you can use or condition in set analysis
=count({$<echeance_date_YYYY={"<$(=year(today()))"},[Notifié cloturée/Non cloturée]={"Notifié cloturée"}>}
+ <echeance_date_YYYY={"<$(=year(today()))"},[Notifié cloturée/Non cloturée]={"Notifié non cloturée"}>}
DISTINCT key_nb_poste_commande)
refer links:
https://community.qlik.com/t5/QlikView-App-Dev/quot-OR-quot-Condition-in-Set-Analysis/td-p/695709
thanks
Vikas
Thanks you all for your help