topic Re: Set analysis question in QlikView

Set analysis question

Tue, 22 Mar 2016 16:21:21 GMT

Hi Experts,

i am new to qlikview and have the following requirement. I have two list boxes in the report showing year and month values.

If only year is selected the dashboard should show the value for the latest completed month, for example if i select 2016 then it should show data for Feb2016, if i select 2014 then it should show data for Dec2014, if i select year,month then the corresponding information.

Could you please let me know some ideas for this.

Thanks a lot.

Re: Set analysis question

sunny_talwar — Tue, 22 Mar 2016 20:25:55 GMT

May be this:

{<Date = {"$(='>=' & Date(MonthStart(Max(Date)), 'DateFieldFormat') & '<=' & Date(MonthEnd(Max(Date)), 'DateFieldFormat'))"}>}

Re: Set analysis question

swuehl — Tue, 22 Mar 2016 20:26:18 GMT

If you select at most a single month, try

=Sum({<month = {'$(=max(month))'}>} value)

This needs numeric month values and a datamodel that don't show month in the future.