- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Tags:
- new_to_qlikview
- « Previous Replies
-
- 1
- 2
- Next Replies »
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
what chart did yu select and what is the expression yu wrote?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Bar chart selected and i have not given any expression.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
You need an expression to calculate from.
Like Count(Customer), this would give you the amount of customer per Country.
Mark
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
where is your expression?
Have your write any expression??
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Dear Narsing,
Kindly find attached document, I hope you are looking for that one.
Kind regards,
Ishfaque Ahmed
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Himanshi,
I got it now and thanks for the reply, grate efforts.
Regards,
Narsing Lal.
- « Previous Replies
-
- 1
- 2
- Next Replies »