topic Re: Can default views be 2 different years in QlikView

Can default views be 2 different years

Mon, 09 Mar 2015 14:35:50 GMT

Our current dashboard is shown weekly with 2015 data. Before the January's results are loaded, can it show December 2014 monthly results when monthly is selected?

Re: Can default views be 2 different years

linusblomberg — Mon, 09 Mar 2015 15:44:40 GMT

You have to provide a lot more information if you want a detailed response. Is it in a chart, in that case what kind. It sound like there are several object that need to change?

You need to change your dimensions into expressions with if statements.

There are several ways to do this but a simple way be something like this:

create a variable in the loadscript with the max(date) of your data. lets call it vMaxDataDate

Dimension:

if(vMaxDataDate<yearstart(today()), Month, Week).

Hope I understood your problem correctly.

Re: Can default views be 2 different years

Mon, 09 Mar 2015 20:24:30 GMT

Default view is weekly for my dashboard. In January 2015 if a user selected monthly, it would be blank. I would like it to go to December 2014 until monthly results for January 2015 were loaded. Can I create a loadscript to show previous (December 2014) year's month ending data even though the default view for the bar charts is showing 2015 weekly data?

Re: Can default views be 2 different years

linusblomberg — Tue, 10 Mar 2015 07:56:08 GMT

So is the problem that on january 2 you will not have any for january? that the data might come on say january 23 or even later? I'm not sure I understand the issue well enough but I'm sure I can help you out once I do.

How do you obatin the default view? is anything selected when you show weekly for jan 2015? if so do you use a trigger for that?

otherwise do you use set analysis to make it show jan 2015?

I think your issue will be solved with a few variables and set analysis.

For your bar charts you can use a variable that contains either week or month depending on your rules for this.

Re: Can default views be 2 different years

linusblomberg — Tue, 10 Mar 2015 07:58:31 GMT

Do this take on of your objects, like a bar chart and tell us the properties. use copy paste

Dimension:

Expression:

Selections (date):