topic showing profit based on selection in QlikView

showing profit based on selection

Wed, 05 Oct 2011 11:09:37 GMT

I have below data...

Customer Name	Customer Country	Customer Total	Supplier Name	Supplier Country	Product	Supplier Total	Profit	% Profit
CUST001	Germany	100	SUPP001	France	OIL	90	10	10.00%
CUST003	France	300	SUPP001	France	OIL	250	50	16.67%
CUST002	Germany	200	SUPP002	Germany	SOAP	150	50	25.00%
CUST004	USA	400	SUPP003	Italy	EGGS	380	20	5.00%
CUST005	Australia	100	SUPP004	Spain	RADIO	80	20	20.00%
CUST008	France	400	SUPP004	Spain	RADIO	300	100	25.00%
CUST006	Italy	200	SUPP005	USA	TV	175	25	12.50%
CUST010	Australia	600	SUPP005	USA	TV	540	60	10.00%
CUST007	Germany	300	SUPP006	India	PHONE	270	30	10.00%
CUST009	USA	500	SUPP006	India	PHONE	460	40	8.00%

I need to show a profit table based on different selection. But want to make only one table.

My table should be displayed with below two columns.

Selection & PROFIT%....

where Selection could be any one from below which can be displayed as either list box, table box or multi box.

Customer Name

Customer Country

Supplier Name

Supplier Country

Product

Please help...

Regards,

Manish

showing profit based on selection

Thu, 06 Oct 2011 07:19:22 GMT

Any reply ?

showing profit based on selection

Thu, 06 Oct 2011 17:23:11 GMT

I've used this workaround before... it may work for you.

Create a variable, say vSelection. Add that to an input box. In the Constraints Tab select Predefined Values in Drop-Down. Then check Listed Values and add this:

='" ", "' & Concat($Field,'","') & '"'

to the expression box. This will give you a list of all available fields. You can also input whatever you'd like and separate them with a semi-colon if you want to narrow your options.

Then within your table use =$(=vSelection) as your dimension and Profit% as your expression. This should give you the info you are looking for.

showing profit based on selection

Fri, 07 Oct 2011 08:50:08 GMT

Thanks for your reply. Can you send me small example by creating qlikview document?

Re: showing profit based on selection

kaushiknsolanki — Fri, 07 Oct 2011 09:31:36 GMT

Hi,

Have a look at the sample file.

Is this what you are looking for..?

Regards,

Kaushik Solanki

Re: showing profit based on selection

Fri, 07 Oct 2011 12:42:50 GMT

Hi Kaushik,

Thanks for your example.

Looks like almost near to what I want.

Actullay, I want output table should be showing profit as below.

If I select Customer Country (I am talking about COLUMN NAME and not individual country), below table should be appear....

Customer Country	Profit%
Australia	11.43%
France	21.43%
Germany	15.00%
Italy	12.50%
USA	6.67%
TOTAL	13.06%

same way if I select Product, below table should be appear.

Product	% Profit
EGGS	5.00%
OIL	15.00%
PHONE	8.75%
RADIO	24.00%
SOAP	25.00%
TV	10.63%
TOTAL	13.06%

Also, I dont have any idea how can I have COLUMN NAMES as a selection. The way you have explained is 100% accurate if I consider wrt to whatever explained in my question, but after rechecking I found that my explanation itselt was wrong at that time.

Please let me know if this is possible.....

Thanks in advance.

Re: showing profit based on selection

Fri, 07 Oct 2011 12:56:28 GMT

Create a inline table for the values you want. Create a List box that has always one value selected. Then add an expression as dimension like:

=If([Field]='Product',Products,if([Field]='Customer Country',Customer Country))

You would of course change the field names and values to match your data.

Re: showing profit based on selection

Fri, 07 Oct 2011 13:47:22 GMT

can you create an example for me.... thanks...

Re: showing profit based on selection

Fri, 07 Oct 2011 13:57:02 GMT

See sample

Re: showing profit based on selection

Fri, 07 Oct 2011 15:29:22 GMT

Here is my example... although it's not working exactly as I thought. It's only showing unique values. It still may be worth checking out for ideas.

Re: showing profit based on selection

Tue, 11 Oct 2011 12:38:40 GMT

It's working perfectly. Thanks to all for your help.