topic Re: format expression in pivot table based off qualifier field in QlikView

format expression in pivot table based off qualifier field

Wed, 19 Oct 2011 02:53:00 GMT

I have a pivot table that I have created where I want to format the data in the pivot based off the values contained in a qualifier field.

For example:

where form = 'late_loads%' the result for the attribute field eg. Jan-2009 should be a %, for everything else the current format is acceptable.

Thanks

Wed, 19 Oct 2011 04:21:32 GMT

I tried to simulate your with some data I have. The following works for me:

Expression:

=if(Right(Form,1)='%',num(Sum(Value),'0.00%'),num(Sum(Value),'#,##0'))

Format:

Expression default.

Result:

Hope this works.

Regards,

Kiran.