If And

[garethct89]

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

erika‌ hic‌ rwunderlich‌ gwassenaar‌

[m_woolf]

Since you are using Count, do you have a Group By expression?