topic Re: x axis values need to change based on filter values in QlikView

x axis values need to change based on filter values

Wed, 25 Nov 2020 16:16:04 GMT

Hi i have scenario

END date 2013

Start date 2019

based on the selection of above,x axis values are change start date is starting and end date is ending.

How to achieve this ?

Please do the needful

Thanks

Thiru

swuehl — Fri, 03 Jun 2016 09:57:38 GMT

Not really sure if I understand your setting, but you can set static min / max for a continuous x-axis (e.g. in a line chart),

and these static values can actually be expressions that evaluate your selections of above dates.

ramasaisaksoft — Fri, 03 Jun 2016 10:57:50 GMT

Hi Thiru,

Try like below

vmindate=min(Book_date);

vmaxdate=max(Book_date);

Dim: =if(BooK_Date>=vmindate and BooK_Date<=vmaxdate ,Book_Date)

Expression:Count(Product)

means your dim will always check min & max dates

if this is not helped to you please post your dummy data and expected output chart.

Fri, 03 Jun 2016 12:46:52 GMT

I got this using input box and i have added predefined values 2013 to 2015 in startdate

and 2013 to 1935 in enddate,

because end user want a drop down for years

This is working but it is static, is there any dynamic solution for this.

Thiru