# App Development

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save \$400 before Dec 31st: REGISTER NOW!
cancel
Showing results for
Did you mean:
Creator III

## 2 two set analysiss expression in one expression

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 🙂

Labels (1)
• ### General Question

1 Solution

Accepted Solutions
MVP

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)

https://community.qlik.com/t5/QlikView-App-Dev/quot-OR-quot-Condition-in-Set-Analysis/td-p/695709

https://community.qlik.com/t5/QlikView-App-Dev/AND-OR-combination-condition-in-set-analysis/td-p/786...

thanks

Vikas

If the issue is solved please mark the answer with Accept as Solution.
If you want to go quickly, go alone. If you want to go far, go together.
3 Replies
Champion III

1) Use a Pivot Table

3) Add dimension "echeance_date_YYYY"  to the column section

4) Drag "Values" from Measure Section to Column Section (above Year)

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
MVP

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)

https://community.qlik.com/t5/QlikView-App-Dev/quot-OR-quot-Condition-in-Set-Analysis/td-p/695709

https://community.qlik.com/t5/QlikView-App-Dev/AND-OR-combination-condition-in-set-analysis/td-p/786...

thanks

Vikas