topic Re: List Box Issue in QlikView

List Box Issue

kishorj1982 — Thu, 25 Feb 2016 19:25:42 GMT

Hello All,

I have 2 source tables concatenated in a single table in Qlik datamodel. These are differentiated by Flag=1 and Flag=2. I am having a list box called week but I want to show only those weeks where Flag=1 and other unrelated weeks (i.e. weith Flag=2) should be grey out.

Is there any way we can do it? For demonstration purpose I have added alternate state in the attachment.

Please suggest me how we can achieve it.

Re: List Box Issue

sunny_talwar — Thu, 25 Feb 2016 20:55:18 GMT

Can a straight table work?

Re: List Box Issue

swuehl — Thu, 25 Feb 2016 20:57:27 GMT

The white / grey background of week values is based on selection state, just as you did in your alternate state.

May i ask why you want to show your list box in this way assuming you haven't selected flag = 1 in your default state?

If you want to show only weeks when flag = 1, use a field list expression

=If(Flag = 1, Week)

Re: List Box Issue

sunny_talwar — Thu, 25 Feb 2016 20:58:33 GMT

You can give it a look and feel of list box:

Re: List Box Issue

kishorj1982 — Fri, 26 Feb 2016 00:23:34 GMT

Hi Swuehl,

Actually - if am not selecting Flag anywhere thats the issue. But the sheet represents data only for Flag=1. As all the expressions using set analysis with Flag=1. List boxes has by default entire data from the data model. But Flag=2 is not relevent here as it the weeks related with it wont display anything hence seems misleading.

Can you please suggest better way to accommodate it?

@ Sunny - No we cant use straight table as the straight table wont enable us selections in green state. Also I want the functionality in the list box as we can separate the relates and unrelated weeks with respect to current selections.

Thanks

Please suggest

Re: List Box Issue

swuehl — Fri, 26 Feb 2016 16:12:35 GMT

Well, if the greyed out weeks are not relevant (Flag = 2), maybe remove them from your list box?

Use a field expression (select <expression> from field drop down on general tab), then enter something like

=If( Flag = 1, Week)

=Aggr( Only({1<Flag = {1}>}Week), Week)