Above/Previous? Issues with current month data

Mon, 10 Sep 2012 16:19:30 GMT

Hi all,

I have a requirement which is as follows:

- A bar chart with 2 dimensions , Date and type

- Each month shows the previous months' data

I have used the above function for this and it works for everything apart f4rom the current month (for which there is no data). e.g. The chart presents correct data until August but September does not get populated so the above function only qworks up until a point.

I also tried the previous function in my script but was unable to get it to work as i was unsure how to order it as there a number of keys in the fact table.

Has anyone any other ideas/examples?

Would be much appreciated.

Thanks

Re: Above/Previous? Issues with current month data

whiteline — Mon, 10 Sep 2012 18:12:05 GMT

You can use an if(rowno()=1) statment as a workaround.

But maybe, it's beeter to change the months labels.

topic Above/Previous? Issues with current month data in QlikView

Above/Previous? Issues with current month data

Re: Above/Previous? Issues with current month data