topic Re: Regarding Formatting in Qlik Automate

Regarding Formatting

Ns7703 — Tue, 21 Jan 2025 07:27:46 GMT

There is a field SFS_Rating and it has values 5-,5+,6-,6+ and so on . I am using this field in gauge chart. What is the correct expression for this so that it show the correct value. I am attaching the screenshot. I need to show this field in Gauge chart . What expression should I use for this?

Re: Regarding Formatting

JandreKillianRIC — Tue, 21 Jan 2025 08:47:37 GMT

Hi @Ns7703

This value is currently seen as a text field. I would change this to make it a number. See script below

Load No, SFS_Rating as SFS_Rating_Original, IF(Len(SFS_Rating) = 2, Left(SFS_Rating, 1) * (Right(SFS_Rating, 1)&1), SFS_Rating) as SFS_Rating; Load * Inline [ SFS_Rating, No 5-, 1 4+, 2 3-, 3 5+, 4 8+, 5 6-, 6];

For the gauge - I would use a sum of the new rating field (Number field) but change the min and max levels.

Result should be something like this.

Regards Jandre

Re: Regarding Formatting

Ns7703 — Thu, 30 Jan 2025 12:10:35 GMT

Thankyou!!

Re: Regarding Formatting

JandreKillianRIC — Thu, 30 Jan 2025 12:20:02 GMT

Hi @Ns7703

Only a pleasure! Glad it was the solution to the issue you were facing!