topic List box to straight table connection in QlikView

List box to straight table connection

Anonymous — Wed, 29 Apr 2015 16:36:32 GMT

Hello all, I have an expression in my list box if(Parindicators2='Y',Networks2)

List Box

North

South

Main

West

in my straight table there is a pivot on Netowrks2 it looks like below

Id Main South North West

1 Y Y

2 Y Y

3 Y

Currently when I select North in my list box I would get column North and West.

Is there a way to only see North column when I select North from the list box, etc?

Results I would like to see.

User selects North in list box and straight table results would be:

Id North

2 Y

Currently I get:

Id North West

2 Y Y

Re: List box to straight table connection

m_woolf — Wed, 29 Apr 2015 17:30:01 GMT

Have you tried using the same code if(Parindicators2='Y',Networks2)for the Networks2 dimension in your pivot table?

Re: List box to straight table connection

Anonymous — Wed, 29 Apr 2015 17:50:13 GMT

Yes, currently I have the below in my straight table.

=MaxString([North)= 'Y'

Re: List box to straight table connection

ramoncova06 — Wed, 29 Apr 2015 18:17:12 GMT

what selection does it appear in your selection box ?

I assume that it would be showing ID 2 and not Networks, right ?

Re: List box to straight table connection

Anonymous — Wed, 29 Apr 2015 18:25:46 GMT

List box:

North

South

East

West

Expression:

if(Parindicators2='Y',Networks2)

Parindicators2 = Y

Networks2 = North, South East and West.

Straight table:

Id North South East West

1 Y Y Y Y

When I select North from the listbox all I want to see is my straight table columns and only the North Column

Hope that helps...

Re: List box to straight table connection

ramoncova06 — Wed, 29 Apr 2015 18:44:55 GMT

what I meant was if you create a current selection box

what do you see

Re: List box to straight table connection

Anonymous — Wed, 29 Apr 2015 18:49:13 GMT

It shows the below when I select on North

Current Selections

Network2 North

Parindicators2 Y

Re: List box to straight table connection

ramoncova06 — Wed, 29 Apr 2015 19:31:35 GMT

what is your expression ?

Re: List box to straight table connection

Anonymous — Thu, 30 Apr 2015 12:54:31 GMT

List box: if(Parindicators2='Y',Networks2)

Straight table: =MaxString([North)= 'Y'

Re: List box to straight table connection

Peter_Cammaert — Thu, 30 Apr 2015 13:06:49 GMT

Is it a Pivot table or a Straight table? An single object cannot be both. I guess you're talking about a Pivot table because your Networks2 field values do appear as column headings...

Re: List box to straight table connection

Peter_Cammaert — Thu, 30 Apr 2015 13:17:19 GMT

Does replacing the current pivot table expression with the following help in any way?

=MaxString({<Parindicators2 = {'Y'}>} Parindicators2)

=Only({<Parindicators2 = {'Y'}>} Parindicators2)

Re: List box to straight table connection

Anonymous — Thu, 30 Apr 2015 14:17:10 GMT

I replaced =MaxString([North])= 'Y' with the above expression in my straight table and still no luck. Yes, I'm dealing with a Stragiht table but I created a Pivot in SQL, sorry for the confusion.

Re: List box to straight table connection

Peter_Cammaert — Thu, 30 Apr 2015 14:36:10 GMT

No problem, I got it.

But then, how come "North" is both a value of field Networks2 and a field in itself (because you are using the field name North in a MaxString() aggregation function)?

Re: List box to straight table connection

Peter_Cammaert — Thu, 30 Apr 2015 14:43:38 GMT

Again because of the SQL PIVOT, I presume?

BTW expressions in a straight table cannot be suppressed in an automatic way (except if there is no data to show, in which case the table collapses to a caption). I guess the best thing you can do is to use the conditional show for each expression and let it test the selections in your listbox.

But that would let you reinvent a behavior that is standard in a QlikView pivot table...