Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Krish2459_58
Creator
Creator

x-axis

Hi ,

I have data like this and I need to show a line chart with x-axis as jan,feb,mar and y-axis as it's total.

 

Jan feb march  april
10 20 30 40
100 200 300 400
10000 20000 300000 40000
Labels (4)
1 Reply
daturpin
Partner - Creator II
Partner - Creator II

This should be straightforward, but usually the table would be formatted where one column was "month" and another column was "sales", and it would look more like:

Jan      10

Jan      20

Jan      10000

Feb     20

etc.  Then you would just have "month" as the Dimension and "=sum(sales)" as the Measure to get what you want.

What you want to do is use the FIELD NAME as the Dimension and sum the values of the field with the matching field name...  Which may be possible but it is convoluted.