VAT if condition display

[#1]

hi

i have VAT column, which consists of rows like VAT14.5, VAT5, NOVAT, as I need to display as

for VAT14.5, i should display as 14.5, 5, 0 likewise

how can i do conditional display.? im  using qlikview 8.5..

Thanks

[Anonymous · Accepted solution]

Hi,

you can do a column with if([VAT column]='VAT14.5',14.5,if([VAT column]=VAT5,5,0))

I hope this can help you.

Best regards.

[MK_QSL]

Use this in your script to create Dynamic VAT in numbers

If(IsText(PurgeChar(VAT,'VAT')),0,Num(PurgeChar(VAT,'VAT'),'#0.00')) as VATNUMBER