Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Not applicable

date fields

I have two date fields AdmDT and StartDt.

Can I display only the dates that match?

=If(AdmDate = StartDt)

Tags (1)
2 Replies

Re: date fields

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

Re: date fields

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.


Rajesh R. S.