topic Re: Date issue in QlikView

Date issue

Wed, 02 Jan 2013 09:07:47 GMT

Im having some trouble with the report i'm developing. I need to have the year and quarter listbox pre-selected, but whenever any of the quarter is selected, the data for the previous quarter goes missing in pivot table.

I'm not sure if it has something got to do with the script i wrote for the for those expression. Below is the script:

Sum({$<PostingYear={$(=Max(PostingYear)-1)},PQuarter={$(=Max(PQuarter)-1)}>}Amount/1000*-1)

Re: Date issue

fosuzuki — Wed, 02 Jan 2013 19:39:16 GMT

What is the content of the field PQuarter? Is it a number from 1 to 4? If you select the first quarter, your set analysis will consider the previous quarter as 0 (zero)...

Re: Date issue

Thu, 03 Jan 2013 01:27:37 GMT

Yes the contents of the field PQuarter is 1 to 4. But this happens even if i select the fourth quarter. I'm very sure that i have data for all the quarters.

Re: Date issue

fosuzuki — Thu, 03 Jan 2013 11:16:51 GMT

Can you send a sample qvw?

Re: Date issue

Fri, 04 Jan 2013 02:36:14 GMT

Ok, I have uploaded the sample. Please check the first and last tab for you to compare.

Re: Date issue

fosuzuki — Fri, 04 Jan 2013 17:38:07 GMT

You have to disregard the selection in the field PostingQuarter. So your formula should be:

Sum({$<PostingYear={$(=Max(PostingYear)-1)},PQuarter={$(=Max(PQuarter)-1)}, PostingQuarter=>}Amount/1000*-1)

Re: Date issue

Mon, 07 Jan 2013 01:29:46 GMT

It really helped thank you so much.