topic Re: Restrict Dimension based on Date in QlikView

Restrict Dimension based on Date

evansabres — Fri, 20 Oct 2017 15:19:56 GMT

I have a straight table in which I want to only show the next ten events based on date. Is this possible within the structure of a straight table and if so, what is the expression? Dimension is EVENTDTE

Re: Restrict Dimension based on Date

sunny_talwar — Fri, 20 Oct 2017 15:41:27 GMT

You can either use calculated dimension to do this or use set analysis... both should be able to handle it... but I would try to do this via set analysis just because it tends to give better performance

Re: Restrict Dimension based on Date

evansabres — Fri, 20 Oct 2017 15:43:06 GMT

Thank you, how would the expression be structured?

Re: Restrict Dimension based on Date

sunny_talwar — Fri, 20 Oct 2017 15:45:06 GMT

What is your current expression?

Re: Restrict Dimension based on Date

evansabres — Fri, 20 Oct 2017 15:45:39 GMT

=SOLDQTY

Re: Restrict Dimension based on Date

sunny_talwar — Fri, 20 Oct 2017 15:52:27 GMT

May be this

Only({<EVENTDTE = {"$(='>=' & Date(Today()) & '<=' & Date(Min({<EVENTDTE = {'>=$(=Date(Today()))'}>}EVENTDTE)))"}>} SOLDQTY)

Re: Restrict Dimension based on Date

evansabres — Fri, 20 Oct 2017 15:55:47 GMT

This makes the sold quantities appear as a null value. The aim is to have only the first ten event dates show, relative to today.

Re: Restrict Dimension based on Date

sunny_talwar — Fri, 20 Oct 2017 15:58:38 GMT

My bad, try this

Only({<EVENTDTE = {"$(='>=' & Date(Today()) & '<=' & Date(Min({<EVENTDTE = {'>=$(=Date(Today()))'}>}EVENTDTE, 10)))"}>} SOLDQTY)

There might be some syntax issue, but the idea to look for EVENTDUE which are greater than today and less than the next 10 EVENTDUE days from today

Re: Restrict Dimension based on Date

evansabres — Fri, 20 Oct 2017 16:00:09 GMT

Thank you