Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Need to get field values for the previous year month

Hi All,

Here is my requirement,

The Values in X for the period 2012-04 <> The values in X for the period 2012-03

Need to calculate the previous period (i.e., here 2012-03) using the current selection (i.e., 2012-04) and using that need to calculate the Values in X field for that period.

I am not sure on how to compare the same field's value for the current period and for the previous period.

Please help in creating this logic.

Thanks in Advance.

8 Replies
Gabriel
Partner - Specialist III
Partner - Specialist III

Hi Leni,

Quick read through your question. This is the Set Analysis I will suggest:

  =sum({$<Period = {$(=only(Period)-1)}>}Sales)

Let me know if this is helpful

Anonymous
Not applicable
Author

Hi Gabriel,

Thanks for your solution.

But my requirement is not this.

Let me try to explain my scenario with ur sample.

I need to compare the Values in Sales field of current selection (2012-04) with the values in Sales field of current selection -1 (2012-03) and using that I need to give true or false value. If it not equal then true else false.

This we are doing to check whether any change is happened to the sales field between the selected period (2012-04) and the period-1 (2012-03).

YYYY-MM = 2012 - 04 & 2012-03

Thanks,

Leni

Gabriel
Partner - Specialist III
Partner - Specialist III

Hi Leni,

Kindly try this.

if(sum({2012-04}sales) = sum({2012-03}sales),"No Change","Changes")

If this doesn't work then provide data in excel file and I can look at it again.

Anonymous
Not applicable
Author

Its not working..

and my requirement is something different.

For Example,

I am selecting Year - 2012, Month - 04, then in straight table it shows either yes or no by doing below comparison.

I am having a field name 'Group' and this field value might change between period. So when I select 2012-04, I have to compare the field value of Group for the Period 2012-04 with the field value of Group for the Period 2012-03 and if the group name is changed (i.e., Group @ 2012-04 <> Group @ 2012-03) then I have to return as Yes else No.

I will not use aggregate funtion in this.

Thanks,

Leni

Gabriel
Partner - Specialist III
Partner - Specialist III

Can you attached sample data

Anonymous
Not applicable
Author

I cannot share the data as it has confidential details.

Not applicable
Author

Have you got the answer for this.If so could you please provide me as well.

Thanks,

Swetha

Anonymous
Not applicable
Author

Sorry I am yet to get the answer.