topic Re: Unhide unselected columns from a table box in QlikView

Unhide unselected columns from a table box

Wed, 27 Nov 2013 09:04:37 GMT

From a sheet I made a bar chart and a table box.

When I clicked a column from the table box, All unselected colums are removed from both charts.

How should I fix the table box to unhide unselected columns.

HELP!! ASAP!! 😉

Wed, 27 Nov 2013 09:07:36 GMT

Can you post a sample app?

sundarakumar — Wed, 27 Nov 2013 09:36:36 GMT

Hi Sundo,

In chart it can be achived by using set analysis.

Please find the attachment with an example.

-Sundar

Anonymous — Wed, 27 Nov 2013 09:45:57 GMT

if you click a column it will hide as qlikview behaves like that it filters the data which you click

however you can lock a graph for click by giving in set analysis like for example : sum({<Year=>}sales)

so if you have a list box or table box and you go on clicking Year then it will not affect bar chart or that chart.

anant

Wed, 27 Nov 2013 09:58:33 GMT

Hi,

please check this link. may be it will helpful for you.

Thanks,

Ashutosh

sundarakumar — Wed, 27 Nov 2013 10:03:36 GMT

Hi Sundo,

That can be achived by alternate states.

Please find the attachement...

I have used two alternate states first and second...

alternate states should be enabled in documnet properties.