Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Query About Charts

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.

11 Replies
gautik92
Specialist III
Specialist III

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

Not applicable
Author

Bar chart selected and i have not given any expression.

Mark_Little
Luminary
Luminary

Hi,

You need an expression to calculate from.

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

Mark

Anonymous
Not applicable
Author

where is your expression?

Have your write any expression??

Anonymous
Not applicable
Author

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

engishfaque
Specialist III
Specialist III

Dear Narsing,

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

Kind regards,

Ishfaque Ahmed

himanshi
Contributor III
Contributor III

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

Not applicable
Author

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.

Not applicable
Author

Hi Himanshi,

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

Regards,

Narsing Lal.