Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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....
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
Yusaf, Thanks .. I Tried...
yes, i tried this approach, but how to hide others???,
and when nothing is selected, then show all..
if nothing is selected then...?
can you share a sample...
i am a bit away from qlikview laptop.. cant try now... share a sample..
dual(
if(Product=getFieldSelections(Product) or GetSelectedCount(Product)=0, Product, ' '),
sum({1} Sales)
)
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
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.
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
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.