Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I'm trying to do and If And in Qliksense Script. I've done exactly the same in Qlikview and it works but not in Qliksense.
if(count(ConExp)>=20 and Transtype = 'Phone Quote','PQ Qualified', 'PQ Not Qualified') as PQ_Qualification
Does anyone see any problems with the syntax as I'm pulling my hair out!
Thanks
Gareth
Since you are using Count, do you have a Group By expression?