topic Re: Current Year Problem in QlikView

Current Year Problem

Anil_Babu_Samineni — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have data like 2009 - 2012

I want to display only 2012 Data using Set Analysis

For Reference, PFA

Re: Current Year Problem

sunny_talwar — Thu, 23 Jun 2016 12:59:32 GMT

May be this Anil:

Sum({$<[Year Order Date] = {$(=Max([Year Order Date]))}>} Sales)

Re: Current Year Problem

MindaugasBacius — Thu, 23 Jun 2016 13:00:53 GMT

Sum({$<[Year Order Date] = {"$(=max([Year Order Date]))"}>} Sales)

Try like this.

Re: Current Year Problem

Anil_Babu_Samineni — Thu, 23 Jun 2016 13:03:35 GMT

Yes, So after that i want to show Last year.

And how to get the data for Max Year Vs Max Year-1

Meantime, I want to show that Difference in Line

Please help me...

Re: Current Year Problem

sunny_talwar — Thu, 23 Jun 2016 13:07:46 GMT

What do you mean a line? How would you want to see a line here?

Re: Current Year Problem

Anil_Babu_Samineni — Thu, 23 Jun 2016 13:09:59 GMT

Yes,

So here i want to know change of 2012 & 2011 ( I want to show that difference in line Chart) with these two graphs..

- Anil

Re: Current Year Problem

sunny_talwar — Thu, 23 Jun 2016 13:13:39 GMT

But difference between two numbers is a single number... How do you expect to see a line?

Re: Current Year Problem

Anil_Babu_Samineni — Thu, 23 Jun 2016 13:16:01 GMT

So, I Apologize that.

I want to know difference Value. How do i get that in Chart, Please?

- Anil

Re: Current Year Problem

sunny_talwar — Thu, 23 Jun 2016 13:24:44 GMT

Are you may be looking for something like this...

Re: Current Year Problem

Anil_Babu_Samineni — Thu, 23 Jun 2016 13:32:30 GMT

Yes, It's similar to that.

Here

Sum(Sales) -- Sum({$<[Year Order Date] = {$(=max([Year Order Date]))}>} Sales)

Above(Sum(Sales)) -- Sum({$<[Year Order Date] = {$(=max([Year Order Date])-1)}>} Sales)

Final Expecting is -- Sum({$<[Year Order Date] = {$(=max([Year Order Date])-1)}>} Sales) - Sum({$<[Year Order Date] = {$(=max([Year Order Date]))}>} Sales)

Re: Current Year Problem

Anil_Babu_Samineni — Thu, 23 Jun 2016 13:36:30 GMT

Sunny Got It.

So, PFA of that image.

Here, i want to show the either Ascending / Descending order?

Is there any expression for that from Sorting?

- Anil

Re: Current Year Problem

sunny_talwar — Thu, 23 Jun 2016 13:41:58 GMT

Dimension is not Date here... I think these expression should work with a dimension which is not a date

This Year -> Sum({$<[Year Order Date] = {$(=Max([Year Order Date]))}>} Sales)

Last Year -> Sum({$<[Year Order Date] = {$(=Max([Year Order Date])-1)}>} Sales)

Difference -> (Sum({$<[Year Order Date] = {$(=Max([Year Order Date]))}>} Sales) - Sum({$<[Year Order Date] = {$(=Max([Year Order Date])-1)}>} Sales))

Re: Current Year Problem

Anil_Babu_Samineni — Thu, 23 Jun 2016 13:48:43 GMT

Sunny,

If i take that expression will coming like below. How to show graphs either Ascending or Descending with Expression from Sorting. For reference, Please find before attachment.

I don't know why -Ve Values came here.

If i take like below. Some kind it is working

(Sum({$<[Year Order Date] = {$(=max([Year Order Date]))}>} Sales)) - (above(Sum({$<[Year Order Date] = {$(=max([Year Order Date])-1)}>} Sales)))

Re: Current Year Problem

Anil_Babu_Samineni — Thu, 23 Jun 2016 13:59:57 GMT

Sunny,

If you have anything about Set Analysis can you please send me that doc's???

- Anil

Re: Current Year Problem

sunny_talwar — Fri, 24 Jun 2016 00:06:02 GMT

Look at the document attached to this link: Set Analysis: syntaxes, examples. Not a perfect document, but will help you learn a lot about set analysis.

Best,

Sunny