Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

prasadmundewadi
New Contributor III

One selection selects multiple fields

I have Opportunity data as shown. Each opportunity has a closed date and a created date. Also a day of quarter.

Oppty          Created Dt          Closed Dt          Created Day of Qtr          Closed Day of Qtr

111               1/1/17                 31/1/17               1                                        31

222               1/31/17               2/15/17               31                                     46

333               1/25/17               1/31/17               25                                     31

444               2/2/17                  2/20/17              33                                     51

User wants to make 1 selection on a 'Day of Quarter' e.g. 31 and that should give him the 1st 3 rows above.

Is there a way to achieve this?

Tags (1)
1 Solution

Accepted Solutions
MVP
MVP

Re: One selection selects multiple fields

May be create a link table

Fact:

LOAD Oppty,

     Created Dt,

     Closed Dt,

     Created Day of Qtr,

     Closed Day of Qtr

FROM ....

LinkTable:

LOAD Oppty,

     Created Day of Qtr as Day of Qtr,

     'Created' as Flag

Resident Fact;


Concatenate (LinkTable)

LOAD Oppty,

     Closed Day of Qtr as Day of Qtr,

     'Closed' as Flag

Resident Fact;

And now select in Day of Qtr field

3 Replies
MVP
MVP

Re: One selection selects multiple fields

Is created and closed day of qtr created in script or are they expressions?

prasadmundewadi
New Contributor III

Re: One selection selects multiple fields

They are readily available in the source table.

MVP
MVP

Re: One selection selects multiple fields

May be create a link table

Fact:

LOAD Oppty,

     Created Dt,

     Closed Dt,

     Created Day of Qtr,

     Closed Day of Qtr

FROM ....

LinkTable:

LOAD Oppty,

     Created Day of Qtr as Day of Qtr,

     'Created' as Flag

Resident Fact;


Concatenate (LinkTable)

LOAD Oppty,

     Closed Day of Qtr as Day of Qtr,

     'Closed' as Flag

Resident Fact;

And now select in Day of Qtr field