Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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 II
Partner - Master II

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 II
Partner - Master II

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 II
Partner - Master II

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