Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
JoseGarcia
Creator III
Creator III

ignore selection

Hi, 

I need expression below to ignore field: Customer_responded
Using this expression, but still not ignoring field.
Any ideas? 

My expression:
count(distinct {<PeriodType = {'YTD'}, Customer_responded=, Flag_First_planned={'1'}, Planned_Project= {'1'}>} [%Key_Fact])

Thanks as always

Labels (1)
6 Replies
BrunPierre
Partner - Master
Partner - Master

Try this

Only({<Customer_responded>} Aggr(Count Distinct({<Customer_responded,PeriodType = {'YTD'}, Flag_First_planned={1},Planned_Project= {1}>} [%Key_Fact]), PeriodType ,Flag_First_planned, Planned_Project))

JoseGarcia
Creator III
Creator III
Author

@BrunPierre
Thanks for the support!
Tried version. did not return expected values 😞

BrunPierre
Partner - Master
Partner - Master

However, was the selection in the Customer_responded field disregarded?

JoseGarcia
Creator III
Creator III
Author

When I applied the Customer_responded filter, field was not disregarded.

BrunPierre
Partner - Master
Partner - Master

Count(DISTINCT{<Customer_responded=>} If(PeriodType='YTD' and Flag_First_planned='1' and Planned_Project='1', [%Key_Fact]))

JoseGarcia
Creator III
Creator III
Author

Formula works but when I apply customer_responded applies value. 
I added two snapshots, I think issue may be that I have two date fields?
JoseGarcia_0-1711126075872.png

JoseGarcia_1-1711126092286.png