topic Re: Monthly data to select with respective year column in QlikView

Monthly data to select with respective column

Anonymous — Fri, 24 Mar 2017 11:47:09 GMT

Hi all,

Mothly info

Re: Monthly data to select with respective year column

sunny_talwar — Fri, 24 Mar 2017 11:52:32 GMT

May be like the attached

=Year([KPI Date])-1

& '/' & Year([KPI Date])

I suggest creating this in the script....

Re: Monthly data to select with respective year column

Anonymous — Fri, 24 Mar 2017 11:59:53 GMT

Thanks - but how ever i would be more interested to get the current fin year than all the years in the filter
and also if i click on 2017/2017 it shows only 2017 data excluding 2016 data
FilnYear Filter box should have only 2016/17 - field( next year 2017/18, later 2018/19...)

Would you please suggest

Re: Monthly data to select with respective year column

sunny_talwar — Fri, 24 Mar 2017 12:02:00 GMT

I am not sure I completely understand... You need 2017/2017 or 2016/2017?

Re: Monthly data to select with respective year column

Anonymous — Fri, 24 Mar 2017 12:03:33 GMT

sorry it was my typo in the last post:

I need 2016/17 in the finyear list box and if i select that the data should have only for 2016/17 data- excluding all the years selections

Hope its a bit better now

Re: Monthly data to select with respective year column

sunny_talwar — Fri, 24 Mar 2017 12:12:23 GMT

May be like attached

Re: Monthly data to select with respective year column

Anonymous — Fri, 24 Mar 2017 13:45:01 GMT

thanks - but cant we done the same in the application side ?

Re: Monthly data to select with respective year column

sunny_talwar — Fri, 24 Mar 2017 13:47:48 GMT

May be using triggers, but why do you want this to be done on the front end? It would be complicated, whereas script based solution is simple and efficient?