Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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