topic Set analysis on dates in QlikView

Set analysis on dates

mosha231 — Wed, 06 Dec 2017 09:40:11 GMT

I have created two list box of same column i.e SALE_DATE. i have set second list box in alternate state. i want to show sales data which is present between two dates selected from two list boxes. Example

dates in list box 1 Dates in list box 2

1/1/2017 1/1/2017

1/2/2017 1/2/2017

1/3/2017 1/3/2017

1/4/2017 1/4/2017

I select 1/1/2017 from list box 1 and 1/3/2017 list box 2

I want to show data which is present between these two dates

can anyone help ? am new to set analysis

Thanks in Advance

Re: Set analysis on dates

Gysbert_Wassenaar — Wed, 06 Dec 2017 09:49:37 GMT

See this discussion: Selecting Arbitrary Date Ranges

Re: Set analysis on dates

mosha231 — Wed, 06 Dec 2017 11:36:36 GMT

First of all thanks for the link.

Is it possible to approach this solution through 2 listbox (as i provided in example) ?

Re: Set analysis on dates

Gysbert_Wassenaar — Wed, 06 Dec 2017 11:43:41 GMT

Yes, it's possible with alternate states and field triggers with select in field actions with complex search strings. Use variables instead like the video tutorial does.

Re: Set analysis on dates

mosha231 — Wed, 06 Dec 2017 14:56:42 GMT

Great.if possible can you guide me for the List box approach..actually according to the requirement can't give manual input in date variables just have to select dates from listbox.

Between i tried methods provided in link but still i have to give manual inputs to run it so can't follow that approach

Re: Set analysis on dates

Gysbert_Wassenaar — Wed, 06 Dec 2017 15:05:12 GMT

I can, but I won't. It's the wrong solution.