Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator III
Creator III

List box to straight table connection

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

13 Replies
Highlighted
Master II
Master II

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

Highlighted
Creator III
Creator III

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

=MaxString([North)= 'Y'

Highlighted
Specialist III
Specialist III

what selection does it appear in your selection box ?

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

Highlighted
Creator III
Creator III

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...

Highlighted
Specialist III
Specialist III

what I meant was if you create a current selection box

what do you see

757515.png

Highlighted
Creator III
Creator III

It shows the below when I select on North

Current Selections

Network2                       North

Parindicators2                   Y

Highlighted
Specialist III
Specialist III

what is your expression ?

Highlighted
Creator III
Creator III

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

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

Highlighted

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...