I am Having Problem with Pivot Table

Wed, 22 Jun 2011 09:58:14 GMT

Hii All,

I have a Pivot table containing 3dimensions(Fld.Name,Month And Date) and 6expressions(Latex,MonthToDate(MTD),YTD,Budget,L/Y Actual for month and L/Y Actual for Date).

My Requirement is:-

1.MTD and YTD shows the value only when Month are expanded,otherwise it will be blank or 0.

And I dont have any idea how to write an expression of LY Actual for Month and LY Actual for Date.

Please guide me.

Thanks & Regards.

Koushik.

I am Having Problem with Pivot Table

brenner_martina — Wed, 22 Jun 2011 10:37:06 GMT

Hi Koushik,

you can enter an if-then-else-statement like:

If(GetSelectedCount(Year)=0,

Sum({<Year={$(=Year(Today()))}>} Budget),

Sum({<Year={$(=Only(Year))}>} Budget))

Greetings from Munich

topic I am Having Problem with Pivot Table in QlikView

I am Having Problem with Pivot Table

I am Having Problem with Pivot Table