topic Re: Pivot table issue ASAP in QlikView

Pivot table issue ASAP

Wed, 19 Nov 2014 11:45:21 GMT

PFA

i dont want the values as mentioned in the screen but am getting the values because of formula.

i dont want values for target % for where group is Total

ashfaq_haseeb — Wed, 19 Nov 2014 12:00:48 GMT

Try like this

LOAD Group,

Passed,

Failed,

if(isnum(Target%),Target%,'') as Target%,

if(isnum(passed%),passed%,'') as passed%

FROM Table

Regards

ASHFAQ

perumal_41 — Wed, 19 Nov 2014 12:11:33 GMT

Hi Venu

Try like below expression

if (Dimensionality ()=0,'NoData',target %)

Wed, 19 Nov 2014 13:00:13 GMT

Hi perumal

Can u please elobrate

perumal_41 — Wed, 19 Nov 2014 13:03:44 GMT

Hi Venu

In expression tab put below code

if (Dimensionality ()=0,'NoData',target % calculation expression )