topic Re: VAT if condition display in QlikView

VAT if condition display

Tue, 07 Jul 2015 14:57:33 GMT

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 — Tue, 07 Jul 2015 15:02:33 GMT

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 — Tue, 07 Jul 2015 15:07:42 GMT

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