topic Re: Re: Graphic / Set Analysis in QlikView

Graphic / Set Analysis

Fri, 03 Jan 2014 22:57:51 GMT

Hi! I’m a beginner to Qlikview.

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

Sum of business retributions selected in a input box (Select Business);
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

Re: Graphic / Set Analysis

rustyfishbones — Fri, 03 Jan 2014 23:09:42 GMT

you could use Select in Field action with a button

Re: Re: Graphic / Set Analysis

rustyfishbones — Fri, 03 Jan 2014 23:10:30 GMT

you could use Select in Field action with a button

does the attached file help you

Re: Re: Graphic / Set Analysis

Sun, 05 Jan 2014 14:33:33 GMT

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.