topic Re: Static Min and Static Max for year in QlikView

Static Min and Static Max for year

Anonymous — Thu, 15 Mar 2018 21:50:16 GMT

I have created a gantt chart out of a bar chart with the field Vendor as the dimension (Y-axis)and 6 stacked expressions representing the date as (x-axis)

Currently it show all years (2017, 2018, 2019, 2020). I want it to display 2018 and 2019 only and am unable to do so. Please help. Thanks

Re: Static Min and Static Max for year

Digvijay_Singh — Thu, 15 Mar 2018 22:54:07 GMT

If you have Year field in your data model, you can use set expressions in your measure, like this may be -

Sum({<Year={2018,2019}>}Value)

Sum(YourDateField={">=$(=Makedate(2018,01,01))"}Value)

Re: Static Min and Static Max for year

Chanty4u — Fri, 16 Mar 2018 06:46:52 GMT

you can try this too

refer the link for more info

Sum({<Year-={2017,2020}>}Value)

https://community.qlik.com/servlet/JiveServlet/showImage/38-4424-102433/Formula1.png

Re: Static Min and Static Max for year

Anonymous — Mon, 19 Mar 2018 16:42:08 GMT

I tried your approach, it did not work. the thing is, my chart has 1 dim but 7 expressions to generate the gantt chart look in the form of a stacked bar chart. the Year field is generated by a link table linking the various dates to the link table. I will post my solution should I find it. Thanks for your input

Re: Static Min and Static Max for year

Anonymous — Mon, 19 Mar 2018 16:42:15 GMT