Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Max Date Values not showing in Report without selection

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.

9 Replies
IAMDV
Master II
Master II

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

Not applicable
Author

Hi,

           Please find attached Application

Regards,

Antony.

IAMDV
Master II
Master II

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

Not applicable
Author

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

IAMDV
Master II
Master II

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

Not applicable
Author

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

- Sridhar

IAMDV
Master II
Master II

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

IAMDV
Master II
Master II

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

llauses243
Creator III
Creator III

Hi Antony,

This is my offer, pls see .rar

Good luck, Luis

El mensaje fue editado por: llauses