topic YTD report in pivot table allowed? in QlikView

YTD report in pivot table allowed?

surajap123 — Tue, 20 May 2014 15:07:44 GMT

Hi All,

I am building YTD in a pivot table. I have 4 dimensions and two expressions. First expression to get current YTD value and other expression is to get previous YTD values.

My first expession ie current YTD is giving right sales result, but previous YTD gives 0.00 as value in every row.

There is no issue with the expession for Previous YTD.

=sum({<Status = {'Cancelled'},CalendarYear={'$(vPriorYear)'},Date={'<=$(vPriorYearDate)'}>}sales)

All the 3 fields Status, Date, and Sales are in the same table(aggregated table in the script)

I wanted to know, is pivot table NOT be used to show YTD for current and previous YTD in each column across set of dimensions?

Where could be the issue, that i need to look at?

Re: YTD report in pivot table allowed?

maxgro — Tue, 20 May 2014 19:17:29 GMT

remove the label from your expression and use the mouse (over) to see your expression

example, my expression is

=sum({<y={$(vPriorYear)},d={"<=$(vPriorDate)"}>} Expression1)

usually it helps to debug set analysis

Re: YTD report in pivot table allowed?

surajap123 — Wed, 21 May 2014 10:59:02 GMT

Hi Massimo,

Actually there was no issue. Infact there was no data for the dimensions during previous year, so i was getting 0.00.

Thanks for your response..