topic Re: Show only some data in graph in QlikView

Show only some data in graph

Thu, 20 Mar 2014 11:38:14 GMT

Hi,

I have a graph with:

- dimension : Person

- espression: SUM(measuse)

I want to show in my table only Person that have SUM(measure) over a certain amout.

You know how to do that?

thank u!

Re: Show only some data in graph

MK_QSL — Thu, 20 Mar 2014 11:42:21 GMT

Like this?

UPDATE FILE ENCLOSED...

Re: Show only some data in graph

Colin-Albert — Thu, 20 Mar 2014 11:42:29 GMT

The dimension Limits tab will allow you to do that based on the first chart expression.

Select "Show values that are Greater than..,."

this can be an absolute amount or a percentage.

Re: Show only some data in graph

its_anandrjs — Thu, 20 Mar 2014 11:43:13 GMT

Hi,

In Dimension

dimension : Person

and in

expression: =if( SUM(measuse) >= 200, SUM(measuse),0 )

Thanks & Regards

Re: Show only some data in graph

its_anandrjs — Thu, 20 Mar 2014 11:45:13 GMT

Hi,

Yes you can use Dimension Limits option also like largest, smallest greater less and in % also

Thanks & Regards

Re: Show only some data in graph

Thu, 20 Mar 2014 11:54:09 GMT

Your other answer works

but i would like to ask: how can I do that in "Dimension Limit"? "Dimension Limit" can limit the dimension, not the expression/measure.... Am I wrong?

Re: Show only some data in graph

MK_QSL — Thu, 20 Mar 2014 11:56:27 GMT

Try...

Calculated Dimension

IF(Aggr(SUM(measure),Person)>=200,Person

Tick Suppress When Value is NULL

Expression = SUM(measure)

Re: Show only some data in graph

MK_QSL — Thu, 20 Mar 2014 11:58:42 GMT

You can also use as below

Create a straight Table

Dimension = Person

Expression = SUM({<Person = {"=SUM(measure)>=200"}>}measure)

Please note that for large data set, Calculated Dimension will slow down your apps but above set analysis gives better performance

Re: Show only some data in graph

its_anandrjs — Thu, 20 Mar 2014 12:01:40 GMT

Hi,

Yes you are right the option limits the dimension according to your choice and it depends on which type of the dimension you are using it is text, number and date. But by dimension if you want to control limit you have to identify in which criteria the expression comes and manage.

Hope this helps

Thanks & Regards

Re: Show only some data in graph

Colin-Albert — Thu, 20 Mar 2014 12:07:38 GMT

Dimension limits will restrict the chart to only show dimensions where the expression meets the limit defined.

Given the original question, adding a dimension limit will apply the restriction on Person, based on the first expression sum(measure) .

So dimension limits will give the result that was asked for without the need to add any other "if" statements or set analysis.

Re: Show only some data in graph

its_anandrjs — Thu, 20 Mar 2014 12:16:52 GMT

Hi,

In addition to this is Dimension Limits tab controls the number of dimension values in your chart. And it depends on the option that you selected and according to that it produces the result. The dropdown contains three values: First, Largest and Smallest. These values control the way the calculation is completed and representing your chart. It is compulsary that you select one of this option.

Hope this helps

Thanks & Regards

Re: Show only some data in graph

Thu, 20 Mar 2014 12:44:39 GMT

Sorry but I can't undersand, for example, if I want only person with SUM(measure)>1000, what should I write in the tab "Dimension Limit"?

Re: Show only some data in graph

Thu, 20 Mar 2014 12:47:55 GMT

It works thank u!

Re: Show only some data in graph

Colin-Albert — Thu, 20 Mar 2014 13:27:53 GMT

Tick the box "Restrict which values are shown using the first expression"

Select

"Show only values that are" "Greater Than" enter the limit value, say 200

then select

"exact amount"

Re: Show only some data in graph

Thu, 20 Mar 2014 15:57:43 GMT

Thank u very much!

Re: Show only some data in graph

Thu, 20 Mar 2014 16:18:26 GMT

excuse me again 'cause now I have a new question (if it's not good here I can open another Discussion but maybe you know the answer).

I thought that "dimesion limit" evaluetes the value of dimension and not the first measure. So, now, what can I do for really limit the value of "dimension"? For examle, same of before:

- dimension : Person

- expression: SUM(measuse)

how can I have a table with only the top 5 person in alphabetical order?

thank u!