How to use QV for compare pricing from my supplier

[#1]

Hi All

I have price from supplier as per enclosed qv doc.

I like to use QV for compare the price for competitor A with competitor B.

Can some one give me suggestion.

SOURCE	BRAND	MODEL	UNITPRICE
COMPETITOR A	KINCO	ABC-001	200
COMPETITOR B	HAKKO	XZY-001	450

May i know how to make the table as below :-

COMPETITOR A	COMPETITOR B
KINCO	HAKKO
200	450

PAUL

[#2 · Accepted solution]

Not sure if I understand you correctly.

might be something like attached.

[#3]

Hi Shy

Wow you are good , i try for 15 min , i still not able to get it right. I can imagine ,

first you convert my table from straight  table to pivot table. then you try to pull the description to right ... etc

I cannot get it right.

Can you share with me how you do it ?

[#4]

Hi Paul,

Yes you are correct. Below are the steps:

1. Convert your table to pivot table, then expand all columns.

2. Once done, click on one of the columns and try moving it right or left or above, a blue arrow will appear indicating where you are moving your column.

3. You can then just drag the columns in whatever order you want them to be and exapand them all again if they get collapsed.

Hope this helps!

[#5]

Hi Shy

Yes i manage to transform the table as your.

PART_NO_	MT4512T	TS1100	Total
Description	10" with non Ethernet	10" with non Ethernet
MAKER	KINCO	HAKKO
	801.5	2270	3071.5

Now my next question is how add one more column to compute the total, as per above table shown amount 3071.5 ( sum of 2 value ) ?

Paul

[#6]

Hi Paul,

Two options:

1. Either you can use AGGR function and then calculate the total. Please find below which may be helpful:

http://community.qlik.com/message/241138

http://community.qlik.com/message/430431

2. You can change the expression to calculated dimension and then use "Show Partial Sum" option from Presentation tab.

[#7]

Hi Sir

I try option 2 , i am unable to get any result.

So i try Option 1.

I need to compute (2270-801)/2270=65%

=sum(aggr(

(

Sum(Column(1))

-

Sum(Column(2))

)

/

Sum(Column(1))

,MAKER,PART_NO_))

But i am still unable to get it display 65%. Hope you can advise me.

[#8]

Hi All

Enclosed my qv doc