topic Re: Refer previous date value using below() in QlikView

Refer previous date value using below()

Wed, 21 Aug 2013 05:40:54 GMT

I have to refer to a previous date value. I have an expression which gives me Maxdate value month wise. I need to calculate the previous day value in the next column. That is, I need something like : Below( Previous calculated column). But it is not working. Any help is appreciated. I am using a straright table.

Thanks.

Re: Refer previous date value using below()

Wed, 21 Aug 2013 08:48:39 GMT

I will explain a bit more,

Month	Date	Closing	Pre Closing
Jan	10-01-2013	11	22
Jan	09-01-2013	22	30
Jan	07-01-2013	30	4
Jan	01-01-2013	4

Closing is a calculated column and I want Pre Closing. Tried Below(Closing) in vain. Can somebody help please?

Re: Refer previous date value using below()

sparur — Wed, 21 Aug 2013 08:55:46 GMT

It should work.

try to use expression like this:

below(sum(Value))

where sum(Value) is Closing expression.

or could you provide qvw example?

Re: Re: Refer previous date value using below()

Wed, 21 Aug 2013 09:12:51 GMT

Thanks Anatoly for your reply.

PFA

While i select multiple company values, it works, but i would have one company selected in real scenario.

Re: Re: Refer previous date value using below()

sparur — Wed, 21 Aug 2013 09:15:13 GMT

What do you mean?

Re: Re: Refer previous date value using below()

Wed, 21 Aug 2013 09:35:19 GMT

In the attached file, if you select multiple companies, you would find some values being populated in the Pre Closing column, but none when one company is selected.

Re: Refer previous date value using below()

sparur — Wed, 21 Aug 2013 09:44:38 GMT

in this case, use Below(TOTAL CurrentClose)

Re: Re: Refer previous date value using below()

Wed, 21 Aug 2013 09:51:34 GMT

Thanks. May I request you to look into the requirement 2 in the attachment? It would be very nice of you.

Re: Re: Refer previous date value using below()

sparur — Wed, 21 Aug 2013 10:05:23 GMT

as I understand, you need show only 5 max Open Interest values...

the simple way is change chart type to straight table and use Dimension limits.

Is it Ok for you?

Re: Re: Refer previous date value using below()

Wed, 21 Aug 2013 10:16:00 GMT

That is a constraint, I have to use pivot. Please suggest a way. Basically, i have multiple transactions against each date and i have to show top 5 of them against each date,company....

Re: Re: Re: Refer previous date value using below()

sparur — Wed, 21 Aug 2013 11:12:52 GMT

look at the attachment

Re: Re: Refer previous date value using below()

Wed, 21 Aug 2013 11:23:33 GMT

Thanks a lot Anatoly. I was struggling with this AGGR, RANK and IF ordering. Now i would look into it carefully and improve my knowledge base for sure.