Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
manpri7078
Creator
Creator

Data for Latest Month available for selected Year

Dear All,

I am trying to build expression for displaying data for latest month for the selected year when only year is selected and month is not selected.

And also data for the previous N number of Months. All this for the dimension defined in the straight table chart.

For Example if I select 2017 and the latest data available is for the month of Jun-17 and If I define N number of months to 5, then my output be

1st Expression -  Data for Jun-17

2nd Expression -  Data for May-17

3rd Expression - Data for Apr-17

and so on till Feb-17.

Please guide me for the expressions to be built in.

Regards,

Manish Prasad

10 Replies
manpri7078
Creator
Creator
Author

No, I want to hide the entire column as if there is only one dimension, as basically that column will not be showing anything. Only it is used for the calculations of the expressions built there in.

Regards,

Manish Prasad