Change row value

[#1]

IF(LEVEL2 = '16.30' AND (len(LEVEL3 > '0')), LEVEL2, LEVEL1) AS LEVEL4

When I load this line, it will output in a pivot table showing 16.3 because in my excel sheet that I load from, 16.30 is shown as 16.3(For I don't know what reason. My company say its like that).

What I would like to do is to change the 16.3 showing in the pivot table to '16.30'. Is there any way I can do it like for example

IF(LEVEL2 = '16.30' AND (len(LEVEL3 > '0')), LEVEL2 AS '16.30', LEVEL1) AS LEVEL4?

The above code does not work btw. Thank very much

[Anil_Babu_Samineni]

Can you provide sample data and expected output to see

atleast, 10 rows we are expecting

[stabben23]

Try use the num()

IF(LEVEL2 = '16.30' AND (len(LEVEL3 > '0')), num(LEVEL2,'##,##'), LEVEL1) AS LEVEL4

[sdmech81]

Try like this,Go to number tab of pivote chart and restrict to 2 decimals

[sdmech81]

Try this it should work!

[#6]

Currently when I use this code, IF(LEVEL2 = '16.30' AND (len(LEVEL3 > '0')), LEVEL2, LEVEL1) AS LEVEL4, I will receive a column of

LEVEL4

16.3

This is because my excel data treats 16.30 as 16.3 and therefore, loaded it as shown.

In reality, the excel data that is 16.3 should be shown as 16.30 on my qlikview. So I would like to know if there is a way to manually load 16.3 but display it as 16.30. So the expected output on qlikview will be

LEVEL4

16.30

[#7]

Sorry tried but it doest work

[stabben23]

I'll think he use this as Dimension value, not expression

[#9]

Sorry but your method is to adjust the cell values decimal points. I would like to change the way my dimensions are being displayed. something like

IF(LEVEL2 = '16.30' AND (len(LEVEL3 > '0')), LEVEL2 AS '16.30', LEVEL1) AS LEVEL4

I would like to manually load that specific LEVEL2 Dimension as '16.30'

[stabben23]

Does you LEVEL2 Field even consist 16.30?

Show us the value in Level2 from Excel without any modifications.