Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
stephenedberkg
Creator III
Creator III

List box selections

i have the two same list box.that is list box 1 and list box 2.

.it contain same data

if i select the list box 1 it affect the list box 2 also

but

my requirement is if i select the list box 1 it does not affect the list box 2

thanks in advance

1 Solution

Accepted Solutions
Not applicable

Go Settings->Document Properties->General->Alternate States-> Add list1 and Add list2

properties left 'brand'

properties right 'brand'

expression

for list1 sum({[list1]} sales)

for list2 sum({[list2]} sales)

View solution in original post

22 Replies
alexandros17
Partner - Champion III
Partner - Champion III

Use alternate states (look in help)

swuehl
MVP
MVP

Not sure if I understand what you are trying to achieve.

You can look into alternate states and set one list box to an alternate states to make selections in both states independent from each other.

stephenedberkg
Creator III
Creator III
Author

do you have any other idea because alternative is not working for my requirement

swuehl
MVP
MVP

What is your requirement and why do you think alternate states won't work for your?

veidlburkhard
Creator III
Creator III

Hi Stephen,

the thing is, if you don't tell us why you need these two independently selectable listboxes, we cannot help you...

So please try to explain a little bit more deeply what you want to achieve.

Burkhard

stephenedberkg
Creator III
Creator III
Author

this is my comparative analysis

i have brands i want to compare the selected brand sales.

my screen short os belowquestions.png

swuehl
MVP
MVP

Looks like a classic case for alternate states. Why do you think it's not working?

stephenedberkg
Creator III
Creator III
Author

i set the alternative state for brand1

now my sales values are working fine.

but when i am going to compare i mean subtract the brand sales which is selected in both brand

that time it is not working.

my formula is below

=if( (GetSelectedCount(Brand) + GetSelectedCount(brands) ) <2

,'Please choose  two field value ',

((sum({<Year={$(=Max(Year))},MonthID={$(=Max(MonthID))},TransactionType={'INVOICE'},brands=,Year=,Month,Quarter=>}$(vSalesBtn))

-

sum({<Year={$(=Max(Year))},MonthID={$(=Max(MonthID))},TransactionType={'CreditNote'},brands=,Year=,Month,Quarter=>}$(vSalesBtn)))

-

(sum({<Year={$(=Max(Year))},MonthID={$(=Max(MonthID))},TransactionType={'INVOICE'},Brand=,Year=,Month,Quarter=>}$(vSalesBtn))

-

sum({<Year={$(=Max(Year))},MonthID={$(=Max(MonthID))},TransactionType={'CreditNote'},Brand=,Year=,Month,Quarter=>}$(vSalesBtn)))

)

)

swuehl
MVP
MVP

Could you upload a small sample QVW with some sample data together with your requested result?

This would make it much easier to help you on your expressions.