topic Re: Set Analysis With <Value & > Value Not Working in QlikView

Set Analysis With Value Not Working

Fri, 03 Oct 2014 11:49:18 GMT

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 — Fri, 03 Oct 2014 11:52:16 GMT

remove space

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

alexandros17 — Fri, 03 Oct 2014 11:53:26 GMT

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

let me know

rubenmarin — Fri, 03 Oct 2014 11:54:17 GMT

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

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

Fri, 03 Oct 2014 11:55:55 GMT

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

Anonymous — Fri, 03 Oct 2014 12:03:56 GMT

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

Regards,

Gabriel