topic Re: A problem with a pivot in QlikView

A problem with a pivot

ecolomer — Sat, 25 Oct 2014 13:07:09 GMT

I have a bar chart with two dimensions and an expression,

I want to present the data (Graphic) in two groups according to the possible values of the variable "Grupo" as seen in the figure, but in each of the groups if there are 3 blocks have values and 3 others have no value because are of other group. See pivot table (no graphic)

As I can do to make each group values appear only if the blocks have value?

The areas marked in red on the chart, I want to disappear.

Thanks for your help

Re: A problem with a pivot

ecolomer — Sat, 25 Oct 2014 17:18:43 GMT

any ideas?

Re: A problem with a pivot

Gysbert_Wassenaar — Sat, 25 Oct 2014 17:41:01 GMT

That cannot be done using two dimensions. You can either create two charts or use only the Bloque dimension. You can use an expression to give the bars of the different groups different colors. See attached qvw.

Re: A problem with a pivot

ecolomer — Sat, 25 Oct 2014 17:55:05 GMT

ok, correct, but how can I put text values groups automated

In my example AAAAA and XXXXX into the graphic (non estatic) Is Possible?

Re: A problem with a pivot

Gysbert_Wassenaar — Sat, 25 Oct 2014 17:58:00 GMT

What makes you think the AAAAA and XXXXX are static?

Re: A problem with a pivot

ecolomer — Sat, 25 Oct 2014 19:17:48 GMT

Non, are the value for Grupo (Variable)

I need the text in the graphic, but if I put them in a table of text or similar are statics

Re: Re: A problem with a pivot

Gysbert_Wassenaar — Sun, 26 Oct 2014 13:07:29 GMT

What you want is not possible afaik. See attached qvw for two alternatives.

Re: A problem with a pivot

ecolomer — Sun, 26 Oct 2014 14:37:36 GMT

Many Thank's

Muchas Gracias.

Saludos,

Enrique Colomer

Re: A problem with a pivot

ecolomer — Mon, 27 Oct 2014 07:13:17 GMT

Finally I've done is create a container with a chart for each value of the Group and has remained as I wanted.

Thanks again for your help.