topic Re: RE:Alternate states in QlikView

RE:Alternate states

Chanty4u — Fri, 24 Jun 2016 10:44:53 GMT

Hi all

I have some issue.

I have two listboxes

Branch and Product.

I have created one alt.state lik S1

I applied S1 to Branch and product is in Default state.

MyReq: wen i select a value in branch the product value shud be reflect.

how can i achieve this?

swuehl — Fri, 24 Jun 2016 10:58:57 GMT

Try a field <expression> in your list box like

=Aggr(Only({s1}Product), Product)

Chanty4u — Mon, 27 Jun 2016 05:14:34 GMT

thnx swuehl

sunny_talwar — Mon, 27 Jun 2016 05:24:46 GMT

Another method would be to use an expression like this:

Sum({<Branch = s1::Branch>}[Top Line Target])

Chanty4u — Mon, 27 Jun 2016 05:27:23 GMT

No sunny.... not in bar chart that shud be reflect for listbox

sunny_talwar — Mon, 27 Jun 2016 05:30:05 GMT

Oh okay... do you mean that something selected in the bar chart should show up in the list box?

Chanty4u — Mon, 27 Jun 2016 05:45:17 GMT

No. bro.. bar chart is exception...

only listbox shud be reflect

sunny_talwar — Mon, 27 Jun 2016 05:47:42 GMT

I think I understand now. I had to check Stefan's app to see what you were trying to do