Show current month when no selection is made

[Anonymous]

Hi there,

Maybe there is an existing discussion about this question, but I couldn't find it. I hope one of you can help me on this.

I am developing kind of a KPI dashboard. On this dashboard I use a gauge chart to show the revenue in the current month. When the user is going into QlikView I would like him to see the status of the current month as default. I think I need to use set analysis for this. The question is: how can I develop the dashboard this way that when the user selects another month, the gauge chart will show the figures for the selected month and not the current month anymore.

I know that setting a trigger on the sheet is an option, but I do not prefer to use that.

Kind regards,

Henco

[sivarajs]

Use something

like sum({$<year={'2012'},Month={"=$(max(Month))"}>}sales)

[Anonymous]

Hi Sivaraj,

Thanks for your reply, I see it is working as I wish to. There is only one thing I don't understand: what does max(Month) say? Is that the max month in my calendar, which is 12 (unfortunately it is month 12 right now which makes it hard to test it :-)) or is it based on the max Month which is related to the used expression?

Kind regards,

Henco

[sivarajs]

Sorry by default it will select the maximum month and shows data

You better use month(today)

[Anonymous]

Yes, but then it is not possible to get the amount of sales for another month in the gauge chart I think?

[sivarajs]

This might helps you to proceed

[Anonymous]

Thanks. I added a date in november. When I select the date in November, I would like to see the amount of 10.

So the default is: today. But after selecting a month/date then see the amount for the selected month/date.