topic Quarterly values should be plotted in QlikView

Quarterly values should be plotted

Fri, 20 Nov 2020 18:02:30 GMT

Hi All,

I have one dimension and three Expressions.

Dimension is calaculated - =if(DATE>='06/30/1947', (DATE))

Expresion 1 - =IF(YEAR >='1949',(Avg({<NAME={'A'}>}VALUE))/100)

Expression2 - = Avg({<NAME={'B'}>}VALUE))/100)

Expression3- =Avg({<NAME={'C'}>}VALUE))/100)

now below image is the display of my final ouput of chart.

In the above image i want yellow cells data to be display like this.

9/30/1950 - -0.86% 9.95% 6.12%

6/30/1951 18.06% -2.45% 2.41%

In Every month if we have two dates with values then we have to club these values into one date value for that month.

Please let me know if you required any additional information

jagan‌ deepaktibhe‌ protossrulus‌

Re: Quarterly values should be plotted

sunny_talwar — Fri, 22 Jan 2016 10:38:22 GMT

Try this as your dimension in that case:

=If(DATE>='06/30/1947', Date(Floor(MonthEnd(DATE))))

=If(DATE>='06/30/1947', Date(Floor(QuarterEnd(DATE))))

Re: Quarterly values should be plotted

Fri, 22 Jan 2016 10:45:53 GMT

No Its not working sunny.

Re: Quarterly values should be plotted

sunny_talwar — Fri, 22 Jan 2016 10:47:22 GMT

Really? those two dates are not getting grouped into one? I am amazed? Can you share a sample where it doesn't seem to work?

Re: Quarterly values should be plotted

deepakqlikview_123 — Fri, 22 Jan 2016 11:18:14 GMT

Hi Avinash,

As suggested by sunny

=If(DATE>='06/30/1947', Date(Floor(MonthEnd(DATE))))

Should work .this was handled previously on ETL side. Why there are so many changes.

thanks

Re: Quarterly values should be plotted

Mon, 25 Jan 2016 07:37:45 GMT

I am really Sorry sunny. The solution is correct and i forgot to sort the order from DATE to QUARTER. Thats why it is showing as a wrong chart but values are correct. It solved thanks a lot sunny