topic Re: Year / minus year qlik sense in App Development

Year / minus year qlik sense

joeybird — Mon, 09 May 2016 13:48:12 GMT

have the expression

as one line on a chart

count(distinct{< CalendarYear = {"$(=max(CalendarYear))"}>} [Custid]) 'Current Year'

and this on a second line on a chart

count(distinct{< CalendarYear = {"$(=max(CalendarYear)-1)"}>} Custid) 'Previous year'

When i pick from a filter pane CalendarYear e.g 2015

current year line appears, but previous year turns to 0, when there is 10 years worth of data

how can i please amend the set analysis to avoid this

kind regards

Re: Year / minus year qlik sense

sunny_talwar — Mon, 09 May 2016 13:50:05 GMT

Are you making the selection just the the CalendarYear field or are there other calendar related fields where you are making selections?

Re: Year / minus year qlik sense

joeybird — Mon, 09 May 2016 13:54:21 GMT

just the CalendarYear field as a filter pane

please help

Re: Year / minus year qlik sense

sunny_talwar — Mon, 09 May 2016 13:58:38 GMT

Would you be able to share screenshots of with and without selection?

Re: Year / minus year qlik sense

joeybird — Mon, 09 May 2016 14:01:31 GMT

no really but

Date is main field of order data

this links to a calendar table, where it links to date, and then to a column called CalendarYear, and column CalendarMonth ect.

the same happens on a pivot chart too.

please help

Re: Year / minus year qlik sense

sunny_talwar — Mon, 09 May 2016 14:11:28 GMT

I don't see anything wrong with the expression you have posted. Unless you can share a sample or screenshot, not sure if I can provide any advice.

Re: Year / minus year qlik sense

joeybird — Tue, 10 May 2016 09:14:55 GMT

i basically have a pivot table (Same for line chart ) that as Months on left hand side... and three columns on the right

Current year, Year -1, and Year-2

i want if someone picks from the filter pane a calendar year 2015

current year becomes 2015, Year -1 shows 2014, and year -2 shows 2013

Please help

Re: Year / minus year qlik sense

Tue, 10 May 2016 11:09:11 GMT

I am going to guess that the "Calendar Year" you use in the filter, is the same one you use in the Set Analysis.

That means when you select 2015 in the filter, it limits your data set to only be CalendarYear = 2015. Your Set Analysis will therefore not return anything for 2014, 2013.

You could create a standalone filter list, in the load script, from CalendarYear, calling it something that ensures it will not automatically link to a field e.g. "MyFilterYear"

Then use that dimension as your filter, changing your Set Analysis to use MAX(MyFilterYear)

Re: Year / minus year qlik sense

joeybird — Tue, 10 May 2016 13:54:22 GMT

thank you team