Hi all,
Is there a way to write a comparison between a variable and a string in an IF-condition without single quotes ' ' ?
E.g. IF('$(vCondition)' = 'A', Field1, Field2)
Some background of why I need this. I have been trying to implement the second solution written in this article. I have a graph that should show a certain measure from a list of calculation-intensive measures based on a condition. As we know, if you place multiple measures within an IF-condition, it will first calculate all the measures, and then provide the result, which makes the app slower and less repsonsive.
Therefore, from this article, I try to build this part:
As you can see, for this we need our measures to be between single quotes.
In my case, I have something like this:
=if(vSelectMeasure=1,
'sum(IF('$(vCondition)' = 'A', Field1, Field2))',
'count(IF('$(vCondition)' = 'A', Field1, Field2))')
In this formula, we have single quotes to show which measure to use (outer-quotes), and within each measure, other single quotes to compare the condition with a string. These latter single quotes will make this fail as Qlik will think it represents the end of the first outer-quotes.
I have already tried multiple solutions not to have single quotes inside this formula, without success:
- Tried to put double quotes here "$(vCondition)" = "A" or on the outside quotes
- Tried to use chr(39) : IF( chr(39)&$(vCondition)&chr(39) = chr(39)&A&chr(39), Field1, Field2)
- This provides a strange result as it returns True for any value of vCondition, so it's not comparing.
- Tried to put this condition in another variable (with and without an = sign before), but Qlik still reads this variable and stops at the first single quote.
- Tried with pick(match()), but it behaves the same as IF.
- Tried with the replace() function to replace a certain character with chr(39), but in there we still need to use single quotes around the special chars.
Do you have an idea of what else I could try to solve this?
