i want to select item details only .how to hide remaining items in qlik view?

[#1]

Hai guys,

in qlik view  I select one item  that show item details and remaining items also show in  unselected position. i  need only selected items.I do not know  how to hide remaining (Unselected) items. please help me, how to hide remaining items.

Regards

Madhu

[jsingh71 · Accepted solution]

Hi Madhu,

As you know unselected items turns gray color. If you dont want to show in list box then go to properties -> in General tab select the 'Hide Excluded' check box. it will hide unselected values.

[er_mohit]

Right click on that list box -->general -->check on hide excluded

hope it helps

[#4]

Thank you jsing it worked.

[MK_QSL]

You can see after selecting hide excluded, the non selected items are occupying the empty space of your list box and dashboard.

better approach is as below. Type below in your list box expression...

Aggr(YourFieldName, YourFieldName)

i.e.

Aggr(Customer,Customer)

now select any customer and see the magic... !!!

[#6]

I do not see any magic

[MK_QSL]

Please check enclosed file.

There are three List Box for the same field Customer.

1st is normal one where you can see all data.. selected + non selected

2nd is using hide excluded

3rd is using Aggr(Customer,Customer)

Hope this helps...

[#8]

I am sorry, I am very new to Qlikview and has a personal version, cannot open a file created by someone else. Below is the screenshot of what I did. What is wrong here?

[MK_QSL]

The idea provided to you is for List Box.