Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

format expression in pivot table based off qualifier field

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:

pivot.bmp

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

1 Solution

Accepted Solutions
Not applicable

Re: format expression in pivot table based off qualifier field

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:

temp.JPG

Hope this works.

Regards,

Kiran.

1 Reply
Not applicable

Re: format expression in pivot table based off qualifier field

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:

temp.JPG

Hope this works.

Regards,

Kiran.