Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
johnsmithqv
Contributor III
Contributor III

Monthly data to select with respective column

Hi all,

Mothly info

1 Solution

Accepted Solutions
sunny_talwar

May be like attached

View solution in original post

7 Replies
sunny_talwar

May be like the attached

=Year([KPI Date])-1

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

I suggest creating this in the script....

johnsmithqv
Contributor III
Contributor III
Author

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

sunny_talwar

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

johnsmithqv
Contributor III
Contributor III
Author

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

sunny_talwar

May be like attached

View solution in original post

johnsmithqv
Contributor III
Contributor III
Author

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

sunny_talwar

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?