topic Re: restrict date based on another date?? in QlikView

restrict date based on another date??

soha1902 — Tue, 24 Jun 2014 17:35:50 GMT

Hi All,

I am using one bar chart where FirstDate is my dimension and Sum(Sales) is my expression.

Now my requirement is, if I user select any date from SecondDate then in chart only thsose date will display which is less then or equal to SecondDate.

For eg. if user select 6/14/2014 from SecondDate filter then chart will show from 6/9/2014 to 3/17/2014.

Please find sample app in attachment.

Re: restrict date based on another date??

vgutkovsky — Tue, 24 Jun 2014 18:12:34 GMT

Well, that kind of depends on the relationship of the 2 date fields. How are they connected in the data model?

Regards,

Vlad

Re: restrict date based on another date??

soha1902 — Wed, 25 Jun 2014 04:47:09 GMT

Hi all,

Any suggestions???

Re: restrict date based on another date??

sujeetsingh — Wed, 25 Jun 2014 05:00:27 GMT

Soha,

You can do the trigger on one date field as select in field and quote condition as where date less than the selected.

The other way is you define a variable which collect the current selected date from Date1 and then use the dimension limit option with this variable

Re: restrict date based on another date??

sujeetsingh — Wed, 25 Jun 2014 05:02:47 GMT

One more option is that you use calculated dimension as if Selected variable is not null then use date in dimension in chart which is less than or equal to the selected date, else the date by default.

Re: restrict date based on another date??

tresB — Wed, 25 Jun 2014 05:06:53 GMT

Try something like:

=Sum({<FirstDate={"<=SecondDate"}>}Sales)

Re: restrict date based on another date??

Gysbert_Wassenaar — Wed, 25 Jun 2014 10:57:49 GMT

I suggest you upload a small example document with some data.

Re: restrict date based on another date??

vgutkovsky — Wed, 25 Jun 2014 14:15:42 GMT

As I mentioned, we need to understand how the 2 fields are related to each other first. Gysbert is right, upload a reduced QVW.

Regards,

Vlad