topic selection in list box in QlikView

selection in list box

Anonymous — Fri, 24 Jun 2016 06:43:32 GMT

Hi Friends,

Below are the two tables

t3:

LOAD * INLINE [

Year, Country1, Sales

2010, India, 1000

2010, Pak, 2000

2011, US, 3000

2012, India, 4000

2014, UK, 5000

2013, Pak, 6000

];

t4:

LOAD * INLINE [

Dummuy

2010

2011

2012

2014

2013

India

Pak

];

i have created a straight table with t3 and a listbox with t4.

When i select any value from Dummuy then according to that straight table should show up.

For example:

if i select 2010 from dummuy then only year and sales should be shown in straight table

if i select india from dummuy then only Country and sales should be shown in straight table.

kindly help me

Thanks in advance

Re: selection in list box

sunny_talwar — Fri, 24 Jun 2016 06:53:07 GMT

Can you check the attached Anusha

Re: selection in list box

jonathandienst — Fri, 24 Jun 2016 06:57:49 GMT

I would do the following:

1. Add a type field to your lookup list:

LOAD * INLINE [

LItem, LType

2010, Y

2011, Y

2012, Y

2014, Y

2013, Y

India, C

Pak, C

US, C

UK, C

];

2. Assuming that Year and Country (Country1?) are dimensions, then use this expression:

=Sum({<Year = P({<LType = {Y}>} LItem)> + <Country1 = P({<LType = {C}>} LItem)>} Sales)

Re: selection in list box

Anonymous — Fri, 24 Jun 2016 10:33:40 GMT

ThankYou Sunny