topic Re: creating a table with limits on the expressions in QlikView

creating a table with limits on the expressions

Mon, 16 Feb 2015 13:15:10 GMT

hi,

i would like to create a table that shows revenues of over x amount and below y amount (e.g 1000<revenue<2000), with the regular dimensions (date, customers, countries etc)

how do i do it?

thanks.

Re: creating a table with limits on the expressions

Anonymous — Mon, 16 Feb 2015 13:20:30 GMT

try

TEST:

noconcatenate load

col1,

col2,

revenue

resident ActTable

where Revenue > 1000 and Revenue < 2000

you can drop noconcatenate when you donot have a table with same column

Re: creating a table with limits on the expressions

sunny_talwar — Mon, 16 Feb 2015 13:21:55 GMT

Try something like this:

Sum({<Revenue = {'>1000<2000'}>}Revenue)

This will only include revenue between that particular range.

HTH

Best,

Re: creating a table with limits on the expressions

jonathandienst — Mon, 16 Feb 2015 13:32:29 GMT

Expression: =If(Sum(Revenue) > 1000 And Sum(Revenue) < 2000, Sum(Revenue))

And make sure suppress zeros is checked (on the Presentation tab)

HTH

Jonathan

Re: creating a table with limits on the expressions

Anonymous — Mon, 16 Feb 2015 13:57:28 GMT

Hi,

Create your graphe with your dimension and the following expression:

if(sum(revenue)>1000 and sum(revenue)<2000,sum(revenue))

Re: creating a table with limits on the expressions

Sun, 26 Apr 2015 18:57:26 GMT

it shows a '-' when the sum is different from the range.

i don't want to see these rows, how do i not show them?

Re: creating a table with limits on the expressions

sunny_talwar — Sun, 26 Apr 2015 19:03:09 GMT

It should not show '-'. Have you used the condition in your dimension or expression? If you used it in dimension, you may need to check 'Suppress when Null' option on the dimension tab of the properties.

Can you share the exact dimension and expression that you are using?

Best,

Sunny

Re: creating a table with limits on the expressions

Sun, 26 Apr 2015 19:06:59 GMT

it's an expression.

i wrote the line "=If(Sum(Revenue) > 1000 And Sum(Revenue) < 2000, Sum(Revenue))"

in the definition rubric, not the conditional rubric

Re: creating a table with limits on the expressions

sunny_talwar — Sun, 26 Apr 2015 19:11:13 GMT

Look at a sample application. Does this help? (PFA)

Best,

Sunny