topic Re: Creating date dimensions from variables in QlikView

Creating date dimensions from variables

swiftfahad — Wed, 25 Nov 2020 16:16:04 GMT

hello grus

On my dashboard I am taking to and from dates from user using calendar and storing those dates in variables

v_fromdate

v_todate

Say after user selection I have a values

v_fromdate: 01-DEC-2016

v_todate : 30-NOV-2017

now is there any way I can set my chart dimensions from 01-Dec-2016 and 31-Dec-2017 in other words how can I map calendar selection from my existing date filed (voucher_Date) already present in table.

I wanna display month wise graph according to user selection

Year-month	Collection
2016-DEC	1500
2017-JAN	1000
-	-
-	-
-	-
-	-
2017-NOV	5000

Re: Creating date dimensions from variables

YoussefBelloum — Fri, 05 Jan 2018 08:52:46 GMT

Hi,

you can use your dates variables in a set analysis, like this:

...{< Date = {">=$(=v_fromdate) <=$(=v_todate)"} >}...

Re: Creating date dimensions from variables

swiftfahad — Fri, 05 Jan 2018 09:33:01 GMT

wht abt dimension? should i break voucher_date into year-month and select as dimension?

Re: Creating date dimensions from variables

Anil_Babu_Samineni — Fri, 05 Jan 2018 09:36:57 GMT

May be this?

If([Year-month] >= Date($(v_fromdate), 'DD-MMM-YYYY') and [Year-month] <= Date(YearEnd($(v_todate)), 'DD-MMM-YYYY'), Date(Date#([Year-month], 'YYYY-MMM'), 'DD-MMM-YYYY')

Re: Creating date dimensions from variables

YoussefBelloum — Fri, 05 Jan 2018 09:37:15 GMT

do you use straight/pivot tables or tablebox for this one ?

as soon as you use expressions you can use the calendar dimensions you want..

give it a try