Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I wanted to use this logic in QlikView, what functions do I use??
Code:
If (Date) is null
then usp* tax
else 0
Explanation:
When the (Date) column is null then 'usp*taxes' else '0'
Try this,
Load *,If(isnull(DATE),USP*TAXES,0) as New Field
From xyz;
Regards,
Kaushik Solanki
Ok thanks .
Load *,If(len(trim(DATE))=0,USP*TAXES,0) as New Field
From xyz;