Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

selection in list box

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

    US

    UK

];

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

or

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


kindly help me


Thanks in advance

1 Solution

Accepted Solutions
sunny_talwar

Can you check the attached Anusha

View solution in original post

3 Replies
sunny_talwar

Can you check the attached Anusha

jonathandienst
Partner - Champion III
Partner - Champion III

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)

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Anonymous
Not applicable
Author

ThankYou Sunny