topic Re: Query About Charts in QlikView

Query About Charts

Tue, 01 Dec 2015 05:34:19 GMT

Hi, Good Morning All,

I'm practising charts.

Confused about what dimension i should take,

I have loaded a 'XL' File,

Loaded Table is 'Customer' and fields are

Customer:

LOAD [Customer ID],

Country,

Customer,

Address,

City,

Zip

FROM

(biff, embedded labels, table is Sheet1$);

I have loaded this table and selected chart and Dimension as 'Country' and then i click Finish, now i see chat is displayed Empty.

Why did i got this issue.....?

What is the mistake that i have done here.

Re: Query About Charts

gautik92 — Tue, 01 Dec 2015 09:24:29 GMT

what chart did yu select and what is the expression yu wrote?

Re: Query About Charts

Tue, 01 Dec 2015 09:33:34 GMT

Bar chart selected and i have not given any expression.

Re: Query About Charts

Mark_Little — Tue, 01 Dec 2015 10:26:46 GMT

Hi,

You need an expression to calculate from.

Like Count(Customer), this would give you the amount of customer per Country.

Mark

Re: Query About Charts

Anonymous — Tue, 01 Dec 2015 10:28:45 GMT

where is your expression?

Have your write any expression??

Re: Query About Charts

Anonymous — Tue, 01 Dec 2015 10:30:25 GMT

in Your case, Country as a Dimension(You shared)

and take expression like: count( distinct [Customer ID]) //will give number of customer w.r.t Country

Re: Query About Charts

engishfaque — Tue, 01 Dec 2015 11:10:17 GMT

Dear Narsing,

Kindly find attached document, I hope you are looking for that one.

Kind regards,

Ishfaque Ahmed

Re: Query About Charts

himanshi — Tue, 01 Dec 2015 11:38:55 GMT

hiii,

you need to write an expression what you want to see in chart.

chart is used to show the data of expression u used on the basis of that field which you select in dimension.

regards,

himanshi

Re: Query About Charts

Wed, 02 Dec 2015 04:48:03 GMT

Hi Ishfaque Ahmed,

Now i got the clarity about the charts after seeing the example, that was to clear and easy to understand.

Thank you, Grate Efforts.

Regards,

Narsing Lal.

Re: Query About Charts

Wed, 02 Dec 2015 04:49:10 GMT

Hi Himanshi,

I got it now and thanks for the reply, grate efforts.

Regards,

Narsing Lal.

Re: Query About Charts

Wed, 02 Dec 2015 04:55:06 GMT

Hi Balaji,

Its not working, i took Dimension as 'Country' and Expression as 'count(DISTINCT[Customer ID])'.

Regards,

Narsing Lal.

Re: Query About Charts

Wed, 02 Dec 2015 04:57:54 GMT

Hi Mark Little,

It worked, Thanks.

I took Dimension as 'Country' and Expression as 'count([Customer ID])'.

Grate efforts.

Regards,

Narsing Lal.