Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)
Use alternate states (look in help)
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.
do you have any other idea because alternative is not working for my requirement
What is your requirement and why do you think alternate states won't work for your?
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
this is my comparative analysis
i have brands i want to compare the selected brand sales.
my screen short os below
Looks like a classic case for alternate states. Why do you think it's not working?
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)))
)
)
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.