topic Re: List box selections in QlikView

List box selections

stephenedberkg — Fri, 21 Aug 2015 13:07:33 GMT

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

Re: List box selections

alexandros17 — Fri, 21 Aug 2015 13:08:10 GMT

Use alternate states (look in help)

Re: List box selections

swuehl — Fri, 21 Aug 2015 13:09:25 GMT

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.

Re: List box selections

stephenedberkg — Fri, 21 Aug 2015 13:25:44 GMT

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

Re: List box selections

swuehl — Fri, 21 Aug 2015 13:34:00 GMT

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

Re: List box selections

veidlburkhard — Fri, 21 Aug 2015 13:34:11 GMT

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

Re: List box selections

stephenedberkg — Fri, 21 Aug 2015 13:46:34 GMT

this is my comparative analysis

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

my screen short os below

Re: List box selections

swuehl — Fri, 21 Aug 2015 13:48:19 GMT

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

Re: List box selections

stephenedberkg — Fri, 21 Aug 2015 13:57:06 GMT

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

)

Re: List box selections

swuehl — Fri, 21 Aug 2015 13:58:47 GMT

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.

Re: List box selections

Fri, 21 Aug 2015 14:08:41 GMT

Hi. Go Settings->Document Properties->General->Alternate States-> Add list1 and Add list2. Then in expressions you mast do Sum({[list1]< .......etc.>} field) and other Sum({[list2]< ...... etc>} field)

Re: List box selections

stephenedberkg — Fri, 21 Aug 2015 14:11:19 GMT

my sample qvw file

Re: List box selections

stephenedberkg — Fri, 21 Aug 2015 14:15:05 GMT

i tired but its not working

Re: List box selections

Fri, 21 Aug 2015 14:16:22 GMT

Can attached qvw?

Re: List box selections

stephenedberkg — Fri, 21 Aug 2015 14:20:22 GMT

qvw files

Re: List box selections

Fri, 21 Aug 2015 14:23:45 GMT

See Settings->Document Properties->General->Alternate States->

Re: List box selections

Fri, 21 Aug 2015 14:26:03 GMT

See Settings->Document Properties->General->Alternate States

Re: List box selections

stephenedberkg — Fri, 21 Aug 2015 14:28:18 GMT

sorry i am using trial version it is does not support for me.

can you post the procedures and formulas

Re: List box selections

Fri, 21 Aug 2015 14:42:04 GMT

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)

Re: List box selections

stephenedberkg — Fri, 21 Aug 2015 14:59:13 GMT

its correct but my requirement is

if i select LG in brand1 and i select apple in brand in brand2

lg sales = 65661

apple sales = 45565

i want the variance of two brands

values is 20096