topic alternative states in QlikView

alternative states

kunkumnaveen — Wed, 27 Jul 2016 10:24:20 GMT

Hello All,

i need help in a requirement,the thing is i got a list box(type) and two same bar charts,

i mean both charts having same dimensions only in expression a slightly change suppose in

first char exp: sum(sales)

second chart exp:sum({group1}sales)..only group is added to 2nd chart exp....

dimesions: type,date

now what i am looking is on selecting a value from type field listbox,i want that value should reflect on both the charts ......

in simple words two charts(normal,group) ,one listbox...

plz any suggestions

sunny_talwar — Wed, 27 Jul 2016 10:26:33 GMT

Try these expressions

1) Sum(sales)

2) Sum({group1<type = $::type>} sales)

Now both your expression are controlled by type in default state.

kaushiknsolanki — Wed, 27 Jul 2016 10:29:56 GMT

Hi,

Your second chart expression should be

sum({group1<Type= $::Type>}sales)

Regards,

Kaushik Solanki

kunkumnaveen — Wed, 27 Jul 2016 10:31:19 GMT

thanks dude ,bang on...............

kkkumar82 — Wed, 27 Jul 2016 10:32:37 GMT

Use like below

sum({group1<[type field =$::<type field>}sales)