Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

line graphs

i have 2 fields (say A and B). A contains months in a year(jan, feb and so on) and B contains (yes, no or maybe).

I need to make a line graph between dimension axis as A and Expression axis as number of counts of yes no or maybe individually.

I mean three line graphs (count (yes) vs A / count(no) vs A / and count(maybe) vs A) in same chart.

suggest any solution(s).

thanks in advance

1 Solution

Accepted Solutions
MarcoWedel

Hi,

I agree that maybe a (stacked) bar chart is better suited for your data, e.g. you could see missing values of one category for one month:

QlikCommunity_Thread_130817_Pic2.JPG.jpg

QlikCommunity_Thread_130817_Pic1.JPG.jpg

hope this helps

regards

Marco

View solution in original post

4 Replies
Not applicable
Author

I think a barchart may be better suited for you.

Use the year as your dimension, then the count for the responses as your expressions

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

A as the first Dim.

B as the second DIm.

Expression: =count(B)

-Rob

MarcoWedel

Hi,

I agree that maybe a (stacked) bar chart is better suited for your data, e.g. you could see missing values of one category for one month:

QlikCommunity_Thread_130817_Pic2.JPG.jpg

QlikCommunity_Thread_130817_Pic1.JPG.jpg

hope this helps

regards

Marco

Not applicable
Author

thank you Marco for detailed explanation. that was really helpful

thanks Rob and Robert