Set Analysis With <Value & > Value Not Working

[#1]

Hi All,

I am trying to achieve a really basic thing:-

Show sales where Dept >11 and also Dept <50

This should be easily do able like this ...

{<Dept = {">11 <50"} >}

but it is completely failing on the attached - could anyone possibly shed any light on this please ?

I have a huge report full of these formulas that are not working and have already spent over half a day on it .. argggghh !

Thank you in advance

Nick

[maxgro · Accepted solution]

remove space

{<Dept = {">11<50"} >}

[alexandros17]

Remove all blank spaces among > 11 < 50, then use single apex not double ' instead of "

let me know

[rubenmarin]

Hi Nick, try removing the space between >11 and <50:

{<Dept = {">11<50"} >}

[#5]

Lol - thanks all so much and don't I feel stupid 😉

[Anonymous]

How you have a lot of formulas on your documents, maybe this site can help you.

http://tools.qlikblog.at/SetAnalysisWizard/QlikView-SetAnalysis_Wizard_and_Generator.aspx

Regards,

Gabriel