topic Re: CHARTS in QlikView

CHARTS

Fri, 11 Dec 2015 15:38:54 GMT

Hi experts,

This is my source file .

Country	Product	Number of Invoices Pending for selected period	Invoices Amount Pending	Number of days invoice is pending	Total Number of customers for which invoices are pending	Invoice Pending Reason
USA	Valve Steel	10	1000	110	2	Customer did not pay on time
USA	Alloy Tool Steel	20	2000	120	4	Money did not received to the account
USA	Stainless Steel	30	3000	130	7	Customer did not pay on time
China	Valve Steel	11	1000	110	8	Customer did not pay on time
China	Alloy Tool Steel	21	2000	120	7	Money did not received to the account
China	Stainless Steel	31	3000	178	2	Customer did not pay on time

please find the attached document This is original "OUTPUT". but i am not getting correct output. anybody help me.

Re: CHARTS

Fri, 11 Dec 2015 16:13:33 GMT

Add Country, Product in dimensions and in the expressions add 4 different expressions with sum(fieldname) for each and check values on data points to display

Thanks,

Re: CHARTS

Fri, 11 Dec 2015 16:16:33 GMT

make country and product dimensions and then the other fields (with the excption of reason) as your expressions, and use sum() function

Re: CHARTS

Fri, 11 Dec 2015 17:25:56 GMT

i have tried but i am not getting correct output can send example with my data and how i can i draw the lines on chart

Re: CHARTS

Fri, 11 Dec 2015 17:40:53 GMT

please attach qvw

thanks

Re: CHARTS

simospa — Sat, 12 Dec 2015 16:26:06 GMT

Hi,

to draw lines in chart you have to to to Chart Properties --> Axes --> check the Show Grid Flag.

Then, I'm sorry but you cannot have 2 dimensions and 4 measures, take a look here:Is it possible to have a grouped bar chart with 2 dimensions without it forcing stacked bars?

Let us know.