topic Re: Dimension as Legends in QlikView

Dimension as Legends

Tue, 14 Aug 2012 06:54:00 GMT

In a chart i want to get Dimension as legends rather than showing on the axis.

In this case Product ID(1,2,3,4) is my dimension which is coming on axis but i dont want to show it on axis. Rather i want to show that as legends. How can i do that ??

Re: Dimension as Legends

IAMDV — Tue, 14 Aug 2012 07:46:47 GMT

Sorry, I'm not clear enough to understand your question. It will be good if you can explain in detail or post the screenshot or sample QVW file.

Meanwhile, please look at this video where I have shown...how to highlight a specific dimension. I hope this technique might help you.

http://qlikshare.com/276

Cheers,

www.QlikShare.com

Re: Dimension as Legends

Tue, 14 Aug 2012 07:59:12 GMT

Say my Chart is like this.

Here I have Month as first dimension and product as second dimension. SO the product ID 1,2,3,4, are coming as legends and Months are on X axis. But in my case i have only one dimension Product whose legend i want to show as shown in the image.

Re: Dimension as Legends

its_anandrjs — Tue, 14 Aug 2012 08:34:40 GMT

Hi,

It is not clear that what diminsion you required but as i understand you take

Dimension -> Monthname, Product

Expression -> Sum(Value)

as i guess am i correct or not please confirm the Dim and Expression what you take.

Thanks

Re: Dimension as Legends

Tue, 14 Aug 2012 08:37:38 GMT

I have only product as dimension. just to show an example of legend type i took month as dimension in the above screenshot. with only Product as dimension i am not getting legend of that type for productid which is there in screenshot. rather it is coming on axis.

Re: Dimension as Legends

its_anandrjs — Tue, 14 Aug 2012 08:46:51 GMT

Hi,

For this add a dummy field like

'Products' as Product_Info

and take this field in the dimension with product dimension,

Dimension -> Product, .Product_Info

Expression -> Sum(Value)

Thanks

Re: Dimension as Legends

kji — Tue, 14 Aug 2012 08:53:21 GMT

Add a calculated dimension that is constant (for example "=1") as the first dimension with "Show Legend" turned off.

Re: Dimension as Legends

Tue, 14 Aug 2012 10:23:00 GMT

This working fine. But when i scroll over the bar it shows me the product ID and the constant value. Is there a way to remove the constant value ??