Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

garethct89
New Contributor

If And

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

erikahicrwunderlichgwassenaar

Tags (5)
1 Reply
mwoolf
Honored Contributor II

Re: If And

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