Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I cannot see the error in my syntax. Can anyone else?
This works and gives me the sum of 'GL_Value' for 'GL_Account_Number's greater than or equal to 9000:
sum({$<GL_Account_Number ={">=9000 " }>} GL_Value )
This works and gives me the sum of 'GL_Value' for 'GL_Account_Number's less than 9200:
sum({$<GL_Account_Number ={"<9200 " }>} GL_Value )
BUT this does not work. It gives me ALL the GL_Account_Numbers, not just 9000 to 9199.
sum({$<GL_Account_Number ={">=9000 <9200" }>} GL_Value )
I want the intersection set, not the union. All the documentation I find has this as the correct syntax but it is not working for me.
I solved my problem. It is not evident in the documentation or in the reference material people have produced.
If you put a space between the start and end points, it won't work.
Note the space between >=9000 and <9200
sum({$<GL_Account_Number ={">=9000 <9200" }>} GL_Value )
Leave NO space and this works as advertised
sum({$<GL_Account_Number ={">=9000<9200" }>} GL_Value )
Can you post a qlikview document that demonstrates the problem?
And maybe this works:
sum({$<GL_Account_Number ={"=GL_Account_Number>=9000 AND GL_Account_Number<9200" }>} GL_Value )
Give this a try:
Sum({$<GL_Account_Number ={"=Num(GL_Account_Number) >= 9000 and Num(GL_Account_Number) < 9200 "}>}GL_Value)
I solved my problem. It is not evident in the documentation or in the reference material people have produced.
If you put a space between the start and end points, it won't work.
Note the space between >=9000 and <9200
sum({$<GL_Account_Number ={">=9000 <9200" }>} GL_Value )
Leave NO space and this works as advertised
sum({$<GL_Account_Number ={">=9000<9200" }>} GL_Value )
I don't think that this should be case, I tested this on one of the applications I am working on and it seems to work with a space between the two.
But whatever may be the case, you were able to get a fix which is more important.
Best,
Sunny
I agree, usually spaces are not critical in QV syntax and Set Analysis but not in this case.
I can see it change before my eyes just by putting a space between and clicking on Apply.
This is Qlikview 11.20.12742.0 SR10 64 bit
I am using Qlikview 11.20.12852.0 SR11 version of QlikView and its working. PFA a sample.
Best,
Sunny