Pie chart % selection should reflect the Transactions in straight table

[hariprasad_koya]

Hi friends,

Can anyone suggest any idea on this...I tried a lot of ways but not able to work it out.The below query should be done at UI level itself.

I just have one query. Though it is loking very simple but iam not able to achieve it. so require help.

I have the salesorder date and sales data sample sheet. only below 2 points to be shown in qlikview

1. Pie chart showing % of Sales <30 days,31-60,61-90,>90 days wrto total sales.(it was created in the QVW)

2.Upon the selection of pie chart slices respective data should be shown in the straight table(Salesorderdate and Sales)

Eg : if i select <30 days slice in pie chart it should show straight table for <30 days transactions.

Please help me out regarding this.Please find the  attachments.

Regards,

Hari

[hariprasad_koya]

Hi Anil,

Can you please suggest any idea on the above query.

Thanks,

Hari

[sasikanth]

HI hari,

its working for me,

Create a variable first name it as vNew and then use the above exp as calculated dimension.