Using Multiple Data Formats in a Bar Chart

Jade_Earley — Fri, 30 Jul 2021 15:25:30 GMT

Good afternoon

I am using Qlik Sense May 2021, Patch 1.

I have an application which loads data from an Excel spreadsheet. This Excel spreadsheet has data in the following formats:
1. Integer (i.e. ####, 1234...
2. Interval (i.e. hh:mm:ss, 01:23:45...)
3. Percentage (i.e. 0.00%, 12.3%...)

The format of the data is defined by a field called MeasureFormat.

I need the Y axis of the bar chart to adapt according to the format of the data. I achieved this before with the following measure expression:

if(MeasureFormat like '*Interval*',Interval(Value,'hh:mm:ss'),

if(MeasureFormat like '0.00%',num(Value,'0.00%'),

num(Value)

)

)

However, this no longer works.
I am not sure if this happened since the latest Qlik Sense upgrade to the May 2021 patch 1, or if the users have changed something within the spreadsheet. Any help or suggestions would be welcomed.

Many thanks

Jade

topic Using Multiple Data Formats in a Bar Chart in App Development

Using Multiple Data Formats in a Bar Chart