Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

date fields

I have two date fields AdmDT and StartDt.

Can I display only the dates that match?

=If(AdmDate = StartDt)

2 Replies
sunny_talwar

May be create a flag in the script

If(AdmDate = StartDt, 1, 0) as MatchFlag

and then use the flag in your set analysis

Sum({<MatchFlag = {1}>}Measure)

Not applicable
Author

Hi Robert,

Solution 1:

While do the data modelling we need to set a field based on the match.

The we can display based on the field.

Solution 2:

You can delete the unmatched records from the temp table and load the remaining data.



Regards,

Rajesh R. S.