Range

[#1]

Hello everyone, I'm new to Qlikview and I have the following problem:

I have the following expression, "(Count ({$ <[Value Rule] = {'X'}>} [Contract Code]))" which tells me that all contracts have an 'X' in "Value Rule" .

Now I need to sort this count ranges, such contracts are between 0 and 10 'X' in rule value.

Thank you very much for the help and sorry for my English.

[jerem1234]

Maybe the class() function could help?

You can maybe have Class([Value Rule], 10) as a dimension, and then Count([Contract Code]) as an expression. What this will do will split out your Value Rule field into ranges suchs as 0-10, 10-20, 20 - 30, etc. Then with the expression, it will count how many contract codes you have in that range of Value Rule.

If this isn't where you were going, could you post a sample qvw showing your problem or explain a little more?

Hope this helps!

[#3]

Thank you very much for answering Jerem, it's just a text box where the number of contracts that are between 0 and 10 'X' is displayed.

I do not know if I explaining this well ...

[jerem1234]

Maybe like this:

=(Count ({$ <[Value Rule] = {'>0<10'}>} [Contract Code]))

Assuming that your field Value Rule is a number and not just 'X'.

Hope this helps!

[#5]

I think that's the problem that my field "Value Rule" only has 'X' ...

Thank you very much for answering