Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QLIKWORLD LIVE! MAY 16 - 19TH, EARLY BIRD DISCOUNTS! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
R0b
Contributor II
Contributor II

Two transactions - One in a table, one in a list box

Hi all,

I have two transactions that are feeding into my Qlikview app. 

I would like to be able to create a table that has data from one transaction, that I can then filter by using a list box based on the other transaction. 

When I try to do this, my table adds additional rows for where there are values in the other transaction that I only want to use in my list box.

Is there a way to stop this from happening, so my table only shows data from the one transaction and then doesn't grow when I make a selection from my list box that is being fed by the other transaction?

Please note there is a link from the first transaction through to the second, but the second transaction does not have a foreign key that links to the first. 

Thanks,

Rob

Labels (4)
1 Solution

Accepted Solutions
Brett_Bleess
Support (Former)
Support (Former)

Did the post regarding using Alternate States get you what you needed?  If so, do not forget to return to the thread and use the Accept as Solution button on that post to give credit for the help they provided.  If you are still working on things, leave an update on what you still need.  You are not likely to receive additional replies unless you do let folks know the idea provided will not work etc.

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.

View solution in original post

2 Replies
jwjackso
Specialist III
Specialist III

I think you can create an Alternate State and assign it to your list box.  Any selections there will not affect tables using the default state.  You can use the P() function to in a set analysis expression to limit data to the list box.

Brett_Bleess
Support (Former)
Support (Former)

Did the post regarding using Alternate States get you what you needed?  If so, do not forget to return to the thread and use the Accept as Solution button on that post to give credit for the help they provided.  If you are still working on things, leave an update on what you still need.  You are not likely to receive additional replies unless you do let folks know the idea provided will not work etc.

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.