Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
remove space
{<Dept = {">11<50"} >}
Remove all blank spaces among > 11 < 50, then use single apex not double ' instead of "
let me know
Hi Nick, try removing the space between >11 and <50:
{<Dept = {">11<50"} >}
Lol - thanks all so much and don't I feel stupid 😉
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