Pivot Table Issue

[#1]

Hi team,
Kindly help me get the following output

I have a pivot table with the following fields

Input Date
Category Name	Product Name	Orders
Jewellery	Ear ring, Ring	20
Watches	Rado, Fossil	10
Electronics	Mono Pad, MINI Pad	30

Issues :
1) I need to calcuate the actual Order contribution against the Category, which is as of giving me a Group result (i.e. 20,10,30)
2) I am not able to sort the Orders (I have tried adding the expression and doing ascending sort, but no luck)

Output Data
Category Name	Product Name	Order	Orders - Actual result
Jewellery	Ear ring, Ring	20/100	0.2
Watches	Rado, Fossil	10/100             0.1
Electronics	Mono Pad, MINI Pad	30/100	0.3

Thanks in advance

[Anonymous]

Hello,

1. Check aggr(), if I understand correctly. Maybe you send your app. On which level you want to see the aggregation? On product level, on category level, or product level divided by category (% contribution)?

2. Check aggr() again for sort purposes. Sorting is tricky in pivot table but can be solved via proper aggr() statements.

BR

Serhan

[#3]

Hi Serhan,

Thanks for the quick reply.

Sorry for missing to provide the aggr level.

I want to aggr on all the above mentioned levels :

1. On product level

2. on category level,

3. Product level divided by category

Thanks

[Anonymous]

Hello,

1. Product level = sum(Orders)

2. Category level = sum(total <Category> Orders)

3. 1/ 2

BR

Serhan

[#5]

Hi Serhan,

Thanks for your inputs. but this seems not to suffice me requirement.

I need to get the % Category for the Orders (just like 20/100=0.2% contribution and so on)

Category Name		Order	Orders - Actual result
Jewellery		20/100	0.2
Watches		10/100                0.1
Electronics		30/100	0.3

As of my current exp is, which is not giving me the required result. can you look into it and provide your inputs.

=Count({1<FACT={'A'}, FLAG={'1'}, ORDERRDATE={'>=$(vFromDate)<=$(vToDate)'}>}ORDER)

/

Count({<FACT={'A'},FLAG{'1'},ORDERDATE={'>=$(vFromDate)<=$(vToDate)'>}ORDER)

Thanks,

[Anonymous]

Hello,

Count({<FACT={'A'}, FLAG={'1'}, ORDERRDATE={'>=$(vFromDate)<=$(vToDate)'}>}ORDER)

/

Count(total <Category>{<FACT={'A'},FLAG{'1'},ORDERDATE={'>=$(vFromDate)<=$(vToDate)'>}ORDER)

Try this. If still not working send me the app.

BR

Serhan

[#7]

Its still not working. And I have shared the sample daat above, can't share the app.

Thanks

[qlikviewwizard]

Hi ruchika123

Please post the some sample data for better understanding and exact solution.