topic Re: Range in QlikView

Range

Mon, 02 Dec 2013 16:11:01 GMT

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.

Re: Range

jerem1234 — Mon, 02 Dec 2013 16:25:35 GMT

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!

Re: Range

Mon, 02 Dec 2013 16:35:28 GMT

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 ...

Re: Range

jerem1234 — Mon, 02 Dec 2013 16:42:06 GMT

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!

Re: Range

Mon, 02 Dec 2013 18:03:25 GMT

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

Thank you very much for answering