topic Re: list box in QlikView

list box

manoranjan_d — Wed, 31 Aug 2016 10:07:07 GMT

=aggr(only({<dept,section=,presentabsent=>}dept),dept)

hi all,

above is my expresson when ever i select the section or presentabsent list box , the dept list box shd all values which shd be active always

that means when ever ection or presentabsent list box the dept list box have exclude the section,

wht is the expression , above i used but it no useful

Re: list box

sunny_talwar — Wed, 31 Aug 2016 10:11:57 GMT

I am not sure I understand what you are trying to get. Would you be able to elaborate a little more?

Re: list box

manoranjan_d — Wed, 31 Aug 2016 10:15:32 GMT

when ever i select the section or presentabsent list box, the dept list shd always have all values that shd be active. this the dept list shd be independent from the section or presentabsent list box. pls dont tell alternate state, tell suggestions in expression itself

Re: list box

sunny_talwar — Wed, 31 Aug 2016 10:17:45 GMT

So you mean regardless of any selection in section of presentabsent, all values should be available for selection within dept? I guess if not the alternate state, then you need a Island Table.

Re: list box

manoranjan_d — Wed, 31 Aug 2016 10:17:54 GMT

example if u select the sec1 in the list box the dept list shd have all dept as active, since it show only IT, so the reamining dept such that cse ece shd be active in dept as IT

Re: list box

manoranjan_d — Wed, 31 Aug 2016 10:18:33 GMT

island is not possile since it dynamic from the table

Re: list box

manoranjan_d — Wed, 31 Aug 2016 10:19:34 GMT

to exclude the selection i use the below expression but its not working

=aggr(only({<dept,section=,presentabsent=>}dept),dept)

Re: list box

manoranjan_d — Wed, 31 Aug 2016 10:25:56 GMT

sunny can you reply me

Re: list box

sunny_talwar — Wed, 31 Aug 2016 10:29:58 GMT

Sure bro, what you are trying to do is not possible AFAIK. The only two ways I can think of is to use alternate state or create a dept field which is associated with all combination of Section and PresentAbsent field (Cartesian Product)

Re: list box

manoranjan_d — Wed, 31 Aug 2016 10:34:42 GMT

can u send me sample file for the (Cartesian Product)

Re: list box

sunny_talwar — Wed, 31 Aug 2016 10:40:17 GMT

Check the attached