topic Re: Max Date Values not showing in Report without selection in QlikView

Max Date Values not showing in Report without selection

Sat, 28 May 2011 19:45:47 GMT

Dear All,

In my report i used following condition, its not working straight table without selection

= sum(if(Date=MaxDate,remainingOutgoing))

For Eg.

if i select customer No. C000003 then it showing the Value, if i press clear button then its not showing on the report.

Can any one help me!

Regards,

Antony.

Max Date Values not showing in Report without selection

IAMDV — Sat, 28 May 2011 20:50:33 GMT

Antony - I think you should use Set Analysis. Please can you post the sample QV document with some data. I can workout an example for sure.

Cheers - DV

Re: Max Date Values not showing in Report without selection

Sat, 28 May 2011 20:55:13 GMT

Hi,

Please find attached Application

Regards,

Antony.

Max Date Values not showing in Report without selection

IAMDV — Sat, 28 May 2011 21:02:05 GMT

Antony - I can see that you had already done some work. I mean I can see this expression...

=sum({$<YearMonth={$(MaxMonth)}>}remainingOutgoing)/100000

When you say straight table do you mean the expression for Remaining? Please provide more details to solve it quickly. I mean I have no understanding of your data model. So please provide more explanation referring to your sample document.

Cheers - DV

Re: Max Date Values not showing in Report without selection

Sat, 28 May 2011 21:18:04 GMT

Hi,

Thanks for your Quick reply.

I need the remainingoutgoing value in straight table but value will be max date value. when u select the customer no. , the customer's last date values i need it on the report. when you click the customer no. C000003 you can see some amount in report when u unselect or clear then it wont show that amount, but i want to show that amount without selecting the customer also.

Hope you understand

Regards,

Antony

Max Date Values not showing in Report without selection

IAMDV — Mon, 30 May 2011 08:47:09 GMT

I am having a problem solving this one. Because the Date in your data is not a single value and we need to compare this with our variable vMaxDate. So I am still trying to think of ways to overcome this issue. I'll get back to you as soon as possible. Meanwhile if someone can contribute that would be brilliant.

Cheers - DV

Re: Max Date Values not showing in Report without selection

Mon, 30 May 2011 09:11:23 GMT

Antony, check this attached application. Hope i understood your problem, if not please correct me.

- Sridhar

Re: Max Date Values not showing in Report without selection

IAMDV — Mon, 30 May 2011 09:21:06 GMT

Sridhar - Thanks Mate. I did follow similar approach with this expression.

Sum({$<Max(Date)={$(=($(MaxDate)))}>} remainingOutgoing)/10000

If you use this expression in Remaining Column it shows up the values but it not right for all the customers. I am afraid same is the case with your example. I mean lets say for example customer : C000002 total should be 34.13 instead of -52.03. And even the [Remaining] value should be 0 instead of -86.61.

I am attaching the file which I am working on. I might be wrong but thats what my understanding is...

Antony - Please correct me if I am wrong.

Cheers - DV

Re: Max Date Values not showing in Report without selection

IAMDV — Mon, 30 May 2011 09:26:29 GMT

Antony - If you see my attachment. I am getting the values for [Remaining] column without selecting the customer. For example for C000003 the value -0.37. However, for other customers the expression is calculating for all the dates instead of calculating for the MaxDate. That's what I need to tackle now.

Also in my example attached the expression should be divided by 100000 instead of 10000. I had amended this and use this expression meanwhile.

Sum({$<Max(Date)={$(=($(MaxDate)))}>} remainingOutgoing)/100000

Cheers - DV

Re: Max Date Values not showing in Report without selection

llauses243 — Mon, 30 May 2011 17:29:12 GMT

Hi Antony,

This is my offer, pls see .rar

Good luck, Luis

El mensaje fue editado por: llauses