Month & Year Selection

[#1]

Hi,

My dashboard consists two filters based on month and year. The requirement is when user selects any month and year and if  the data is not there for that selection the charts should display "No data to display", but currently what is happening is if user selects any combination and if data is not available for that particular month and year what QV is doing is, it is automatically selecting the max year for that particular month if data is available. Can anyone help me to rectify this issue.

Thanks,

Gaurav

[kaushiknsolanki]

Hi,

You need to change the expression accordingly.

Regards,

Kaushik Solanki

[#3]

Hi Kaushik,

A lame question to ask but do i have to make changes in chart expressions or filter.

Thanks

[Gysbert_Wassenaar]

If you use standard listboxes to select year and month then the user can immediately see if a month-year combination exists after selecting either a month or a year. There's no need for complicating things when all you need to do is explain to the users how making selections in Qlikview works. Green = selected, White = possible values, Grey = excluded values.

But if you insist on this requirement you will have to use alternate states and set analysis expressions. This tutorial should give you an idea: Using Alternate States to Select Multiple Values in a List Box with Different Attributes