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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources 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