topic Re: embedding 2 modules data in one chart in QlikView

embedding 2 modules data in one chart

ali_hijazi — Thu, 31 Oct 2013 14:04:52 GMT

Hello

I got the following data (check attached)

I want to create a bar chart and add as dimension the field Group

but I want to see for the values of G1 and G2 the total of Amount

is this feasible or I have to have the data in a different format?

Please advise

Re: embedding 2 modules data in one chart

Gysbert_Wassenaar — Thu, 31 Oct 2013 15:44:01 GMT

See attached qvw

Re: embedding 2 modules data in one chart

ali_hijazi — Fri, 01 Nov 2013 07:30:53 GMT

no this is not what I want it should be G1 corresponding to 1500 and G2 corresponding to 3000; following the country and branch

Re: embedding 2 modules data in one chart

Gysbert_Wassenaar — Fri, 01 Nov 2013 07:33:09 GMT

Why? What is the logic behind that?

Re: embedding 2 modules data in one chart

ali_hijazi — Fri, 01 Nov 2013 07:48:38 GMT

we are getting data into one QVW document for two modules but we are trying to make comparisons

the modules are related to Disciplinary actions, and performance management, and sales

for example from those whose result was exceptional or satisfactory how was their contribution to sales in the next 6 months or after the performance evaluation interview was made, or out of those who were marked as exceptional , satisfactory what is the percent of employees out of each bracket who had disciplinary infraction

Re: embedding 2 modules data in one chart

Gysbert_Wassenaar — Fri, 01 Nov 2013 07:58:36 GMT

Why does G2 correspond to 3000 and not to 1500 or 1000 or 3.14? What is the logic? What does the source data look like?

Re: embedding 2 modules data in one chart

ali_hijazi — Fri, 01 Nov 2013 08:22:09 GMT

G1 is related to Branch B1 in PMS and in Sales B1 has 1500 as amount and so on

Re: embedding 2 modules data in one chart

Gysbert_Wassenaar — Fri, 01 Nov 2013 18:58:21 GMT

I think you used a concatenate in the script where you should have used a join.