Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I am a new user of QlikSense, and I am having difficulty with doing a certain task. I'm sure it's fairly simple, but I don't know how to go about this. Here is a screenshot of a table I am working on:
In the 'Closed Unqualified" column, I wanted to show "1" for every time the "StageName" column is "Closed Unqualified". Currently, it is showing "0," which is incorrect. I tried this function, but it didnt work : "IF(StageName="Closed Unqualifed",1,0)
Can someone please guide me in how I can achieve my objective and fix the "Closed Unqualified" column? What is the right function I need to input to get the right values? Thank you so much in advance for your assistance!!
If you are using double quotes " try using single quotes ' around Closed Unqualified also ensure your spelling is correct as Unqualified is wrong in your if statement.
Try:
if(StageName = 'Closed Unqualified',1,0)
If you are using double quotes " try using single quotes ' around Closed Unqualified also ensure your spelling is correct as Unqualified is wrong in your if statement.
Try:
if(StageName = 'Closed Unqualified',1,0)
have u tried with simple quotes?
IF(StageName='Closed Unqualifed',1,0)
Thank you very much! That worked perfectly!
Thank you very much! That worked perfectly!
Thanks again your your help! I was wondering if there was a way to combine IF statements?
For example, would this be correct: If(StageName !='Close Unqualified', StageName !='Verfication',1,0) ?
I am adding a column to the table that has to include StageName values that excludes 'Closed Unqualified" and "Verification."
If(StageName !='Close Unqualified' or StageName !='Verfication',1,0)