Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
As new in Qlik Sense, I have a problem while using IF. How to correct it? Many thanks.
If([Storage Day]<=30,'0~1',If([Storage Day]>30 and [Storage Day]<=90,'1~3','0'))
@My_Rebecca try this
If([Storage Day]<=30,'0~1',If([Storage Day]<=90,'1~3','0'))
if looks good
can you verifie by puting this expression in interface
I try it in the interface, succeed, but why fail in Data manager? How to enable it work in Data manager?
@My_Rebecca try this
If([Storage Day]<=30,'0~1',If([Storage Day]<=90,'1~3','0'))
The AND / OR keywords are not available in Data Manager. You'll have to rewrite your conditions using nested If() statements as suggested by @Taoufiq_Zarra or switch to using Data Load Editor.
It works, thanks.
thanks for your interpretation.