What sell with my item

[ajithsachin]

Hi All,

     i have a table contain invoice wise item wise sales data.

     if i select one item one report should show which item is selling more along with the selected item considering invoice.

     below i am mentioning the sample table format.

Invoice	Item	Date	sales qty
1	item1	01-04-2015	10
1	item2	01-04-2015	11
1	item3	01-04-2015	12
1	item4	01-04-2015	13
2	item1	02-04-2015	20
2	item2	02-04-2015	21
2	item3	02-04-2015	22
2	item4	02-04-2015	23
3	item1	03-04-2015	30
3	item2	03-04-2015	31
3	item3	03-04-2015	32
3	item4	03-04-2015	33

         Can anybody help please..

Regards,

Ajith

[Anonymous]

Something in this direction:

=FirstSortedValue({<Item=E(Item)>}  Item, -aggr(sum({<Item=>} [sales qty]),Item))

I could've missed something in the requirements, so you maybe need to adjust.

[ajithsachin]

HI Michael,

     Thank you very much for the help.

     From this i am not getting which item is selling more with my one item.

     As per the sample data if i select 'item1' i should get the report like this

Item	sales qty
item4	69
item3	66
item2	63

      because along with item1, item4 is selling more.(in every invoice along with item1, item4 is there.)

      Hope you understand the requrement.

Regards,

Ajith

[anbu1984 · Accepted solution]

Check this app

[qlikviewwizard]

Hi ajithsachin001

Can you show us desired out put.

[ajithsachin]

Hi,

     Out put will be like this

Item	sales qty
item4	69
item3	66
item2	63

     This means along with item1, item4 is selling more qty then item3 and item2.

     This should consider the invoice number like in one invoice item1 should be there and along with which item is selling more.

[ajithsachin]

Thank you very much..