topic Graph column in Pivot Table in QlikView

Graph column in Pivot Table

marco_puccetti — Mon, 20 Apr 2015 13:36:18 GMT

Hello i need to add a graph dimension in a pivot table, can you tell me how to set the minimum and maximum range in the settings?

I set the minimum and maximum like 0, 999999999 but it seems to not show me nothing of significant data.

Thanks

Marco

Re: Graph column in Pivot Table

ali_hijazi — Mon, 20 Apr 2015 13:41:50 GMT

you can specify this in the expression itself

for example I got a pivot table and i have a cell to display count of a metric from a date date1 to a another date date2

the expression is as follows:

count

(

DISTINCT

{

Year=

,Month=

,CALENDAR_DATE={">= $(vFromDate) <=$(vToDate)"}

,RECORD_TYPE={'WASTE'}

}TEST_ID)

and the result is as follows:

Re: Graph column in Pivot Table

marco_puccetti — Mon, 20 Apr 2015 13:54:34 GMT

I need a graphic column that represents the previous numeric count of data.

In my example there is a field that contains the count of a field, so i need a graphic expression used to show this in a linear graph mode.

This is the expression:

The settings

This is the result

Re: Graph column in Pivot Table

ali_hijazi — Mon, 20 Apr 2015 14:03:36 GMT

86 compared to 99999999 is too small to be represented

instead of putting 99999999 put an expression like =max(your_field)

Re: Graph column in Pivot Table

marco_puccetti — Mon, 20 Apr 2015 14:09:42 GMT

If i use this expression, in the column:

=Max(Count({< FLAG_SMATERIALIZZATO = {"S"}>}FLAG_SMATERIALIZZATO))

is reported this error:

"Minimum and Maximum Value wrong for the graph". (I have translated from itaian version)

Marco

Re: Graph column in Pivot Table

ali_hijazi — Mon, 20 Apr 2015 14:13:19 GMT

use max(aggr(sum.....,your_dimension))

Re: Graph column in Pivot Table

ali_hijazi — Mon, 20 Apr 2015 14:14:57 GMT

can you send me a sample qvw file?

Re: Graph column in Pivot Table

marco_puccetti — Mon, 20 Apr 2015 14:33:43 GMT

What do you intend for dimension in case of use of this formula:

=Max(Count({< FLAG_SMATERIALIZZATO = {"S"}>}FLAG_SMATERIALIZZATO))

Marco

Re: Graph column in Pivot Table

ali_hijazi — Mon, 20 Apr 2015 14:36:57 GMT

use

max(aggr(count({< FLAG_SMATERIALIZZATO = {"S"}>}FLAG_SMATERIALIZZATO)),Dimension))

Dimension is the column you added in your dimension list

Re: Graph column in Pivot Table

marco_puccetti — Mon, 20 Apr 2015 14:55:20 GMT

I have added this expression:

max(aggr(count({< FLAG_SMATERIALIZZATO = {"S"}>}FLAG_SMATERIALIZZATO)),DATA_PRES)

But it still doesn't work.

Marco

Re: Graph column in Pivot Table

ali_hijazi — Mon, 20 Apr 2015 15:00:24 GMT

look just add 500 for now in the max and check if you can see the graph

send me a sample qvw file to give you the correct expression

Re: Graph column in Pivot Table

marco_puccetti — Mon, 20 Apr 2015 15:03:59 GMT

No, it doesn't work.

Marco

Re: Graph column in Pivot Table

marco_puccetti — Tue, 21 Apr 2015 08:38:38 GMT

I can't send you the qvw.

Try with the information you have!!

Thanks

Marco

Re: Graph column in Pivot Table

ali_hijazi — Tue, 21 Apr 2015 09:11:13 GMT

I can do nothing

you can scramble your document and reduce it if you want

scramble all text columns and reduce the document and I'm ready to help

Re: Graph column in Pivot Table

marco_puccetti — Tue, 21 Apr 2015 10:07:41 GMT

Now it seems to work if i put a variable containing the max value for that data.

If i use the circular graphic view instead the percentage is showed only if data is trunked to the int and it seems is not allowed the float number.

Is it right?

Marco