Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
pgalvezt2021
Partner
Partner

Many If Sentence inside Set Analysis pie chart

Hello !

I have this formula that is failing when filtering a dimension, the idea is that the graph does not move with the INTERM dimension.

 

If(Cod_Filtro_Dim=5,
If(CodFS=1 and Cod_Filtro_V=3 and Cod_Filtro_P=1,
Count({<ID_PROG={'35','63'},per={'$(vPer_Act_Cober)'},FLAG_IGUAL_OTOR_PER_MES={'1'},INTERM=>}ID_OPE),
Count({<ID_PROGRAMA={'35','63'},periodo={'$(vPer_Act_Cober)'},ID_EST={'70'},INTERM=>}ID_OPE)),0)

Thanks!

2 Replies
Digvijay_Singh

Would be great if you can share a sample app and the expected out, very difficult to understand your need, at least for me.

pgalvezt2021
Partner
Partner
Author

Hello,

 

Thanks for your reply !

unfortunately I can't, any help without having to upload some file. I have seen that they solve this type of formulas without having a sample. Can someone help me with this please? Thanks !!!