topic Re: Surpressing certain values/dimensions in chart in QlikView

Surpressing certain values/dimensions in chart

zagzebski — Thu, 21 Mar 2013 19:43:37 GMT

I have the following chart:

Type: Line Chart

dimensions: Years, Product

Expression : Sum(Sales)

Basically I want to surpress any product that doesn't have at least 10,000 in total sales across all years I have selected.

Re: Surpressing certain values/dimensions in chart

CELAMBARASAN — Thu, 21 Mar 2013 19:49:50 GMT

Use Dimension limits.

Show Only Values that are and set Greater 10000 with exact amount

Re: Surpressing certain values/dimensions in chart

zagzebski — Thu, 21 Mar 2013 19:54:03 GMT

looks like this must be a different version. I don't see dimension lmits as a tab. We are using version 10.

Re: Surpressing certain values/dimensions in chart

CELAMBARASAN — Thu, 21 Mar 2013 20:22:20 GMT

Yes its version 11.

For 10 there will be no option like that. You have to do restriction in expression.

If(Sum(Total<Product> Sales)>=10000,Sum(Sales))

Hope it helps

Celambarasan

Re: Surpressing certain values/dimensions in chart

zagzebski — Thu, 21 Mar 2013 20:38:56 GMT

I think this is on the right track but it is totalling for ALL products. I want it to evalutate product by product.

for instance we have 12 products. I want each product to show in the line chart UNLESS it has less than 10,000 in sales

Re: Surpressing certain values/dimensions in chart

CELAMBARASAN — Fri, 22 Mar 2013 13:47:23 GMT

Can you upload the sample?

i need to know where it fails for you?

Re: Surpressing certain values/dimensions in chart

Anonymous — Tue, 26 Mar 2013 19:08:33 GMT

Try to replace your Product dimension with this calculated dimension:

aggr(only({<Product={"=sum(Sales) > 10000"}>} Product),Product)

and, don't forget to check "suppress when value is null"

Regards,

Michael

Edit: now you can have more fun if replace constant value 10000 with a variable, and create an input box or slider where user can change this limit.

aggr(only({<Product={"=sum(Sales) > $(Limit)"}>} Product),Product)

Re: Surpressing certain values/dimensions in chart

zagzebski — Tue, 26 Mar 2013 19:34:35 GMT

Micheal -

All I have is a line chart with

Dimension- =aggr(only({<[Product]={"=sum(Sales])> 10000"}>} [Product]),[Product])

and

Expression = sum([Sales])

I get No data to display ( when I check "suppress when value is null")

Re: Surpressing certain values/dimensions in chart

Anonymous — Tue, 26 Mar 2013 23:56:39 GMT

You have also Year dimension, don't you? What if you add Year to aggregation in the expression for Products:

aggr(only({<[Product]={"=sum(Sales])> 10000"}>} [Product]),[Product],Year)

What if you change 10000 to a lesser limit?

If nothing works, attach a sample application.

Regards,

Michael