topic Re: Dimension Labels Hide in QlikView

Dimension Labels Hide

israrkhan — Thu, 21 Nov 2013 08:21:57 GMT

Hi Community,

I want to Hide dimensions labels,

let say , i have a bar chart, with one dimension product, and one expression sum({1}values)

let say,Dimension having values ProductA, ProductB, ProductC, ProductD.

now i want to show only labels of dimension, which are selected,

let say ProductA is selected, so i want to show only ProductA Label, and want to hide other all labels which are ProductB, ProductC, ProductD, but the bars will be shown for all , as i am using sum({1}values).

i think you got it,....

Idea Please....

Re: Dimension Labels Hide

bbi_mba_76 — Thu, 21 Nov 2013 08:36:24 GMT

Hi,

maybe you could set ' ' as dimension label and a value as datapoint.

Re: Dimension Labels Hide

israrkhan — Thu, 21 Nov 2013 09:03:06 GMT

where should i set this, if want to talk about dimension tab>>label, then it will only hide the Heading of Dimension,

but not the values, as ProructA, ProductB...

Re: Dimension Labels Hide

bbi_mba_76 — Thu, 21 Nov 2013 09:10:42 GMT

But, I think you cannot hide the value with a calculated dimension or move the dimension label (ctrl+shift).

Maybe you could add leading spaces for the non selected product....

but I have no other ideas..

Re: Dimension Labels Hide

israrkhan — Thu, 21 Nov 2013 09:26:30 GMT

ITS NOT CALCULATED DIMENSION...

when nothing is selected, it should show all labels, but when 1 is selected then only that should be.

Re: Dimension Labels Hide

Thu, 21 Nov 2013 09:34:56 GMT

Is it really necessary to hide the other product names?

Why not use color or shading to emphasize the selected product?

You could use, for example, the following background color expression:

IF(SubStringCount(Concat(DISTINCT [Dimension],'|'),[Dimension])=1,RGB(255,0,0))

Re: Dimension Labels Hide

bbi_mba_76 — Thu, 21 Nov 2013 09:36:28 GMT

In fact.

Maybe you could use the text color or with a text box over the dimensions...

Re: Dimension Labels Hide

jagan — Thu, 21 Nov 2013 09:37:14 GMT

Hi Khan,

I think it is not possible even I tried with Dimension - Text Color but it only works for Straight/Pivot tables, there is no such setting and work around. Let's see any other users have any ideas.

Regards,

Jagan.

Re: Dimension Labels Hide

Thu, 21 Nov 2013 09:42:55 GMT

Hi ,

Have you tried using the below stuff

=GetFieldSelections(DimensionName) in the dimension

Regards

Yusuf

Re: Dimension Labels Hide

bbi_mba_76 — Thu, 21 Nov 2013 09:44:06 GMT

Or with text on axis and something like

dual(

if(Product=getFieldSelections(Product), Product, ' '),

sum({1} Sales)

)

Re: Dimension Labels Hide

israrkhan — Thu, 21 Nov 2013 09:45:51 GMT

Hi Jagan,

i also tried to much, but no success,

and now just wanted to listen from a senior, thats its not possible.

and you done the job..

Thanks

Re: Dimension Labels Hide

israrkhan — Thu, 21 Nov 2013 09:46:49 GMT

Yusaf, Thanks .. I Tried...

Re: Dimension Labels Hide

israrkhan — Thu, 21 Nov 2013 09:48:31 GMT

yes, i tried this approach, but how to hide others???,

and when nothing is selected, then show all..

Re: Dimension Labels Hide

israrkhan — Thu, 21 Nov 2013 09:51:38 GMT

if nothing is selected then...?

can you share a sample...

i am a bit away from qlikview laptop.. cant try now... share a sample..

Re: Dimension Labels Hide

bbi_mba_76 — Thu, 21 Nov 2013 10:00:00 GMT

dual(

if(Product=getFieldSelections(Product) or GetSelectedCount(Product)=0, Product, ' '),

sum({1} Sales)

)

Re: Dimension Labels Hide

israrkhan — Thu, 21 Nov 2013 10:27:45 GMT

BBI MBA, thank you For your effort,

but its not perfect...you are doing text on axis techniques, but when you select data on data point,

so its stop working and also Relative..

any way, you have done a nice effort.. Thank you again..

Khan

Re: Re: Dimension Labels Hide

jagan — Fri, 22 Nov 2013 02:37:11 GMT

Hi Khan,

Finally I got it by adding one more expression (as Text on axis) and making use of Expression-Text Color. Please find attached file, hope it helps you.

Regards,

Jagan.

Re: Dimension Labels Hide

israrkhan — Fri, 22 Nov 2013 11:58:41 GMT

Hi Jagan,

Thank you so much, its almost fine.. but did not work when i change >> orientation to vertical.

you done a great job.

Thanks

Khan

Re: Re: Dimension Labels Hide

jagan — Fri, 22 Nov 2013 13:26:58 GMT

Hi Khan,

It is working for Vertical Orientation also, just click on chart and Press Ctrl + shift and drag the chart from left to right. So that you will see the axis.

Please find attached file. Hope it helps you.

Regards,

Jagan.