topic Re: list box issue in QlikView

list box issue

manoranjan_d — Thu, 25 Aug 2016 09:12:39 GMT

Hi all,

I have attached the sample for the list box what i need is if i select the IT in the list and if i select the sec1 in the section list, sec4 and sec5 are hiding i need that value.

i got successful on the section available for the specific dept such that unavailable section are getting hide for the specifc dept, but the

issue is when i select the section value in the list the other values are getting hide, so the value in the section should not hide how to acheive it

Re: list box issue

adamdavi3s — Thu, 25 Aug 2016 09:45:48 GMT

Well your items are hiding as the list box is using an expression rather than simply using the field name.

I can't quite see why you would do this in this situation, but the simple issue is either:

1- just use the field name

2- alter your listbox expression to this:

=AGGR(Only({1}SECTION),SECTION)

Please remember to mark this as helpful or the correct answer if I have helped you or answered your question.

Re: list box issue

sunny_talwar — Thu, 25 Aug 2016 09:55:36 GMT

You need this?

Try this:

=AGGR(Only({<SECTION>}SECTION),SECTION)

Re: list box issue

manoranjan_d — Thu, 25 Aug 2016 10:15:47 GMT

Thaks

Re: list box issue

sunny_talwar — Thu, 25 Aug 2016 10:17:11 GMT

No problem

Re: list box issue

manoranjan_d — Thu, 25 Aug 2016 10:32:13 GMT

i need one more help

=aggr(only(DATE(created_date,'DD-MMM-YYYY')),created_date)

how to apply for this?

Re: list box issue

sunny_talwar — Thu, 25 Aug 2016 10:44:04 GMT

What are you trying to apply here? Just a pure guess here:

=Aggr(Only({<created_date>} Date(created_date,'DD-MMM-YYYY')), created_date)