topic Re: Monthly trended view wrong in QlikView

Monthly trended view wrong

Anonymous — Wed, 19 Feb 2014 19:25:15 GMT

Hi friends,

I have 2 charts:

left chart - shows total

right chart -shows by months (trend)

It works well when it's full months.

But when I select some days in May 23- May 31, my trended chart is wrong.

How can it fix?

Thanks,

Gysbert_Wassenaar — Wed, 19 Feb 2014 19:34:18 GMT

Using the same expression in both charts would help. You now have different expressions, so you get different results.

Anonymous — Wed, 19 Feb 2014 19:39:10 GMT

When I use expression from left chart (it shows total respondents)

it's completely wrong results

individual counts/ total count for whole periods

I need individual counts/ count total by Months or Date

I dont know how to set up trended chart depended of calendar

jerem1234 — Wed, 19 Feb 2014 19:42:55 GMT

How exactly is it wrong? Your column is for the whole month of May, when you select the days, you are only selecting part of May (May 23- May 31).

Can you explain a little more of why the values are wrong, and what values you are expecting?

Maybe you want to just get the MYear from the dates like:

Count({<oDate=, MYear = p(MYear)>}[qID_15863_Purpose of Visit])

/ Count(ALL<MYear>[qID_15863_Purpose of Visit])

Hope this helps!

Anonymous — Wed, 19 Feb 2014 19:47:39 GMT

I wanted to have the same results as left chart

May 23-31 selected days, total count for these days -134, but for whole month- 181

I think I got it

Count([qID_15863_Purpose of Visit])/

Count(TOTAL<MYear,oDate>[qID_15863_Purpose of Visit])

Anonymous — Wed, 19 Feb 2014 21:03:43 GMT

it's final version for my purpose

Count([qID_15863_Purpose of Visit])/

Count({<[qID_15863_Purpose of Visit]=>}TOTAL<MYear,oDate>[qID_15863_Purpose of Visit])