topic Re: Sum for each column value in pie-chart in QlikView

Sum for each column value in pie-chart

razvan_brais — Wed, 25 Nov 2020 16:16:04 GMT

Hy guys , I have a table in which I have this kind o data:

ID	Description	Sales
1	Laptops	50
1	Phones	130
1	Watches	40
2	Laptops	60
2	Phones	75
3	Laptops	30

I want to show in a pie chart values for a selected ID for each type of description.

I don`t want to use Description as a dimmension because I need to bring in this pie chart values from other tables .

Thank you

Re: Sum for each column value in pie-chart

Anil_Babu_Samineni — Thu, 13 Oct 2016 09:09:17 GMT

Where is the other table,

ID - Dimension

Expression - Sum({<ID=, Description = {"*" - Aggr(GetFieldSelection(ID),Description)}>}Sales)

Re: Sum for each column value in pie-chart

susovan — Thu, 13 Oct 2016 09:24:04 GMT

Is it your requirement?

Re: Sum for each column value in pie-chart

razvan_brais — Fri, 14 Oct 2016 08:13:21 GMT

Thanks a lot guys for your answers , but I have change a bit the aproach. I brought all my info in one table because I wanted to avoid all these calculation that could make my app work slowly.

Re: Sum for each column value in pie-chart

rupamjyotidas — Fri, 14 Oct 2016 14:48:52 GMT

Its a good thing to close the discussion , once you have solved your problem. Thanks

Re: Sum for each column value in pie-chart

deepakqlikview_123 — Sat, 15 Oct 2016 04:53:16 GMT

Hi,

Create the composite key for first 2 col.

Use that as a dimension and put label as per ur naateed. Or cree extenal inline tble for showing associatons and name that as per req.

Thanks