topic Calendar Object in QlikView

Calendar Object

Sat, 13 Aug 2016 08:40:47 GMT

Hi,

I'm having data for two years. I used calendar Object for Date. My business case is.

if customer selects date in the calendar object. user must the selected date, Previous month same date and previous year same date and month. what to display in line graph or bar graph.

Ex:

if customer selects 1Aug2016 from calendar,

1aug2016 1july2016 1aug2015

10 9 16

Could you help how to achieve this

Enclosed same data.

Re: Calendar Object

settu_periasamy — Sat, 13 Aug 2016 19:58:02 GMT

You can try with dimension less bar chart..

Expression 1: sum(Offerings)

Previous month: Sum ({<Date={'$(=Date(addmonths(Max(Date),-1)))'}>}Offerings)

Previous year: Sum ({<Date={'$(=Date(addmonths(Max(Date),-12)))'}>}Offerings)

Re: Calendar Object

Mon, 15 Aug 2016 05:42:43 GMT

Hi,

for prior month the above logic is not working. Its showing count as 0.