topic Re: If statement in QlikView

If statement

maternmi — Mon, 11 Nov 2013 09:44:32 GMT

Dear all,

we have orders which are invoiced and which are not invoiced yet. I would like to show within a diagramm at the invoice date field the invoice date, if there is one. If there is no one I want to display a text (no invoice yet) instead of "-".

how can I do it within a diagramm.

I've tried

=if([invoice date] = 0 ,'no invoice yet', [Fakturadatum])

but I dosen't works. Does somebody knows the solution?

Thanks for helping!

Best regards,

Michael

Re: If statement

kaushiknsolanki — Mon, 11 Nov 2013 09:47:07 GMT

Hi,

Try this.

Load Invoice_Id,

Invoice_Date,

If(isnull(Invoice_Date),'No Invoice Yet','Invoice Generated') as Invoice_Flag

From xyz.

Regards,

Kaushik Solanki

Re: If statement

Mon, 11 Nov 2013 09:58:43 GMT

Hi,

You need to use either the isnull() function or the alt() one.

If(isnull([invoice date]) ,'no invoice yet', [Fakturadatum])

the alt() function gives you the second result if the first one is empty;

Alt([Fakturadatum]), ‘no invoice’)

Fabrice

Re: If statement

jagan — Mon, 11 Nov 2013 10:25:40 GMT

Hi,

You can also do the same by using Len() like this

if(Len([invoice date]) = 0 ,'no invoice yet', [Fakturadatum])

Regards,

Jagan.