Graphic / Set Analysis

[#1]

Hi! I’m a beginner to Qlikview.

I’m trying to create a graphic with the following expressions:

1. Sum of business retributions selected in a input box (Select Business);
2. Average of business retributions selected in a list box (Select Benchmark). If I choose:
   1. Option 1 – Commercial Farm  - I consider only business number 4 and 95;
   2. Option 2 – State Company – I consider only business number 112 and 95;
   3. Option 3 – Poultry Company – I consider retribution of businesses number 112 and 4;

I try to use these variable:

• vBusiness: business chosen;
• vBenchmark: benchmark option chosen;

Please find attached an example.

Any suggestions greatly appreciated.

Regards,

Andrea

[rustyfishbones]

you could use Select in Field action with a button

[rustyfishbones]

you could use Select in Field action with a button

does the attached file help you

[#4]

Hi! Thank you for your help!

I have more questions:

1) How can I connect my input box to my graphic business expression?

2) I used a very simple example, but I need to create a lot of benchmarks with many business records. There is another way to create benchmarks? maybe using a list box? How can I connect the benchmark selected to my graphic average expression?

I will be grateful if you can send me these informations.