topic Re: Show current month when no selection is made in QlikView

Show current month when no selection is made

Anonymous — Wed, 05 Dec 2012 10:07:36 GMT

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

Re: Show current month when no selection is made

sivarajs — Wed, 05 Dec 2012 10:16:13 GMT

Use something

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

Re: Show current month when no selection is made

Anonymous — Wed, 05 Dec 2012 10:31:39 GMT

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

Re: Show current month when no selection is made

sivarajs — Wed, 05 Dec 2012 10:40:52 GMT

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

You better use month(today)

Re: Show current month when no selection is made

Anonymous — Wed, 05 Dec 2012 10:42:34 GMT

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

Re: Show current month when no selection is made

sivarajs — Wed, 05 Dec 2012 10:55:02 GMT

This might helps you to proceed

Re: Show current month when no selection is made

Anonymous — Wed, 05 Dec 2012 10:58:52 GMT

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.