Pivot table formatting issue (2 formatting types- Only 1 type will show)

helen_pip — Fri, 16 Oct 2015 13:09:26 GMT

Hello

I have been building an aggregated level of data in my script to be displayed in a pivot table. Data values will be a mixture of % and hh:mm in 1 nested if statement

I have noticed that when writing all formatting in the script, the pivot table will only accept 1 of those formats in the 1 nested if expression. If I want all data items to show then formatting does not work for any data values.

Do you know if it is possible to do all formatting in the script for 2 different types of formats (% and hh:mm) and for it to show accurately in the pivot table for 1 nested if statements?

Kind Regards

Helen

topic Pivot table formatting issue (2 formatting types- Only 1 type will show) in QlikView

Pivot table formatting issue (2 formatting types- Only 1 type will show)