topic Re: Clickable Bar without dimension in QlikView

Clickable Bar without dimension

Fri, 11 Dec 2015 20:00:37 GMT

Hi Team,

Below is my table and chart. If I click the bar, it should show it individually. I took 3 expressions each has count(field) but no dimensions.

Table:

LOAD * Inline [

ID1,ID2,ID3,Date

1,18,31,12/12/2014

29,15,31,11/12/2015

10,13,1,10/12/2015

12,13,1,11/19/2015

];

Please suggest

rwunderlich — Fri, 11 Dec 2015 21:52:16 GMT

The only thing I can think of is to load a data island with a proxy dimension and use that as the chart dim.

LOAD * INLINE [

ProxyDim

]

;

Then use ProxyDim as the Dimension, and an expression of:

Pick(ProxyDim

,count(ID1)

,count(ID2)

,count(ID3)

)

You can color the background as:

=color(ProxyDim)

Not sure how to get a legend if you need one. See attached.

-Rob

Fri, 11 Dec 2015 22:28:52 GMT

Thanks so much Rob, that was wonderful