topic Re: line graphs in QlikView

line graphs

Tue, 26 Aug 2014 17:09:46 GMT

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

Tue, 26 Aug 2014 17:29:55 GMT

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 — Tue, 26 Aug 2014 17:33:22 GMT

A as the first Dim.

B as the second DIm.

Expression: =count(B)

-Rob

MarcoWedel — Tue, 26 Aug 2014 22:47:06 GMT

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:

hope this helps

regards

Marco

Wed, 27 Aug 2014 04:45:21 GMT

thank you Marco for detailed explanation. that was really helpful

thanks Rob and Robert