topic Re: Above and Below function in QlikView

Above and Below function

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

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

Re: Above and Below function

Frank_Hartmann — Thu, 20 Sep 2018 12:29:56 GMT

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

Re: Above and Below function

vishalgoud — Thu, 20 Sep 2018 12:50:07 GMT

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

Re: Above and Below function

gayathridevi24 — Thu, 20 Sep 2018 12:57:41 GMT

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.

Re: Above and Below function

gayathridevi24 — Thu, 20 Sep 2018 12:59:50 GMT

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

The above expression is not working me.

Could you please help me to solve this issue.

Re: Above and Below function

Frank_Hartmann — Thu, 20 Sep 2018 13:11:41 GMT

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

Re: Above and Below function

Frank_Hartmann — Thu, 20 Sep 2018 13:19:27 GMT

is this what you are expecting?

Re: Above and Below function

gayathridevi24 — Thu, 20 Sep 2018 13:24:23 GMT

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

Re: Above and Below function

Frank_Hartmann — Thu, 20 Sep 2018 13:31:25 GMT

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

Re: Above and Below function

Frank_Hartmann — Thu, 20 Sep 2018 14:47:17 GMT

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