Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

ecolomer
Honored Contributor II

A problem with a pivot

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

p10.png

1 Solution

Accepted Solutions

Re: Re: A problem with a pivot

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


talk is cheap, supply exceeds demand
8 Replies
ecolomer
Honored Contributor II

Re: A problem with a pivot

any ideas?

Re: A problem with a pivot

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.


talk is cheap, supply exceeds demand
ecolomer
Honored Contributor II

Re: A problem with a pivot

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

What makes you think the AAAAA and XXXXX are static?


talk is cheap, supply exceeds demand
ecolomer
Honored Contributor II

Re: A problem with a pivot

Non, are the value for Grupo (Variable)

P00.png

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

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


talk is cheap, supply exceeds demand
ecolomer
Honored Contributor II

Re: A problem with a pivot

Many Thank's

Muchas Gracias.

Saludos,

Enrique Colomer

ecolomer
Honored Contributor II

Re: A problem with a pivot

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.

Community Browser