Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

alemberg
New Contributor II

Date List with Set Analysis

I am pulling out a list of dates on to my dashboard, but I would like to display only the dates related to a status of scheduled or completed. I cant seem to figure out the correct syntax.

Thank you in advance

1 Solution

Accepted Solutions
MVP
MVP

Re: Date List with Set Analysis

How about this:

Date as dimension

Only({<Status = {'scheduled, 'completed'}>} [Start Time]) as expression

4 Replies
MVP
MVP

Re: Date List with Set Analysis

May be this:

Aggr(Only({1<status = {'scheduled, 'completed'}>} DateField), DateField)

Re: Date List with Set Analysis

or create the Flag in script like below

LOAD *,

          if(match(status,'scheduled','completed'),Date,null()) as DateNew

......

Now you can directly use DateNew as Dimension

if Status & Date fields are from different table then go for what sunny has suggested

alemberg
New Contributor II

Re: Date List with Set Analysis

Allow me to clarify as I am still doing something wrong. When I drag the attribute "Start Time" I am getting a list of dates. I would like only the dates which are associated with the "Status" of Scheduled. I will do another list for Completed.

I am starting with the following in the expression [Start Date]

MVP
MVP

Re: Date List with Set Analysis

How about this:

Date as dimension

Only({<Status = {'scheduled, 'completed'}>} [Start Time]) as expression