Above and Below function

[gayathridevi24]

Hi All,

I am using above and below expression. It is not working fine.

Please find the attached qvw file. Could all please help me to solve this issue.

Thank you all in advance.

Thanks and Regards,

Gayathri Devi

[Frank_Hartmann]

not sure if this meets your requirement, but give it a try

[vishalgoud]

what you are trying to achive, do you want to add the previous month result to current month ??

[gayathridevi24]

Hi Vishal,

Actually am trying to compare the two months and see the difference.

I want to see the difference between current month and next month.

I want to know the working of above and below function.

[gayathridevi24]

if(month='jan',0,data-above(data))

The above expression is not working me.

Could you please help me to solve this issue.

[Frank_Hartmann]

make sure that the sorting of your dimensions are correct! otherwise below and above will not work as expected!

[Frank_Hartmann]

is this what you are expecting?

[gayathridevi24]

Hi Frank,

Yes, I am expecting this result only. Thank you so much for your support.

Could you please share me the qvw file.

Thanks and regards,

Gayathri devi

[Frank_Hartmann]

I already attached this qvw in my first post. i guess you are watching this thread through your Inbox.

Try to open the link to the thread directly and you will see my attached file!

Above and Below function

hope this helps

[Frank_Hartmann]

did this resolve your requirement?

If yes then please close this thread. if not feel free to share your thoughts

Qlik Community Tip: Marking Replies as Correct or Helpful