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: 
raghavsurya
Partner - Specialist
Partner - Specialist

One variable dependent on other variable

Hi All,

I have a set of data consisting of brands and their products.  We are doing a sales projections under  what-if scenarios in which the user will be able to alter the sales % of few brands/products and the what-if values do change only for those brands/products. For Example

Brand                                     Product

Samsung                              21' TV

Samsung                              29" TV

Samsung                              42" TV

Samsung                              Automatic Washing Machine

LG                                        21' LCD TV

LG                                        29" LED TV

LG                                       42" LED TV

LG                                       Automatic Top Open Washing Machine

The requirement is we have defined a variable for Brand and another variable for Product.  We have provided input boxes with dropdown of  Brand and Products as well.  If the user selects Samsung in the First input box (variable as Brand) the Product variable should display only products related Brand selected in first input box.

Can anybody suggest how to build the dependency between two variables.

Regards,

Raghav

6 Replies
kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi Raghav,

                You can use the Multibox instead of the drop down input box.

                You can also set the variable with selected value of ur multibox.

                Hope this will help you

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
raghavsurya
Partner - Specialist
Partner - Specialist
Author

Hi Kaushik,

Thanks for your reply.  

The sales projections are to be changed only for the Brand/product we select... multibox solution does not help us.

Regards,

Raghav

kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

     Can you please upload the sample QVW file.

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
Not applicable

Hi,

as my understand i uploaded one file.plz check it.

Thanks&Regards

Chandra

kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi

  

     I am unable to figure out what output you require..

     Can you tell me in detail with an example

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
oscar_ortiz
Partner - Specialist
Partner - Specialist

Is this what you are attempting to do?

Have a look at the two variables I've created on Sheet 1.

Then have a look at the document properties | triggers for what I do with these variables.

Hope this helps

Oscar