Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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....

Anonymous
Not applicable
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?

Anonymous
Not applicable
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

Anonymous
Not applicable
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?