Discussion board where members can get started with Qlik Sense.
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!
erika hic rwunderlich gwassenaar
Since you are using Count, do you have a Group By expression?