Discussion board where members can get started with Qlik Sense.
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?
Go to Solution.
May be create a link table
Created Day of Qtr,
Closed Day of Qtr
Created Day of Qtr as Day of Qtr,
'Created' as Flag
Closed Day of Qtr as Day of Qtr,
'Closed' as Flag
And now select in Day of Qtr field
Is created and closed day of qtr created in script or are they expressions?
They are readily available in the source table.