topic Max Date Values not showing in Report in QlikView

Max Date Values not showing in Report

Fri, 27 May 2011 09:49:39 GMT

Dear All,

In my report i used following condition, its not working 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

kaushiknsolanki — Fri, 27 May 2011 10:00:20 GMT

Hi,

if you are using this in listbox ot textboxm it will not work because Date is a field and contains many values.

What you can do is create a Straight table-> give dimention as Date and use the above expression in expression.

This will work. or else upload the qvw.

Regards,

Kaushik Solanki

Re: Max Date Values not showing in Report

Fri, 27 May 2011 10:09:16 GMT

I used the Expreesion in Straight Table but its not working....

Re: Max Date Values not showing in Report

Fri, 27 May 2011 10:09:56 GMT

Hi,

Please find attached Application...

Regards,

Antony.

Re: Max Date Values not showing in Report

Fri, 27 May 2011 10:12:58 GMT

Please check the feild "Remaining"

Max Date Values not showing in Report

kaushiknsolanki — Fri, 27 May 2011 10:27:48 GMT

Hi,

It will not work, as i said earlier Date is not a single value. When you give dimension as Date the expression takes Each date. The reason is each row of a date dimnension is a single date and which can be compared with your maxdate.

Think about your expression it. sum(if Date= MaxDate,........) what date you expect to be comapred with MaxDate.

I hope you understood the problem

Regards,

Kaushik Solanki

Max Date Values not showing in Report

kaushiknsolanki — Fri, 27 May 2011 10:31:59 GMT

Hi,

You can use set analysis like Sum({$<Date = {$(#MaxDate)}>}remainingOutgoing)

This will give you the sun only if you have customer with remainingOutgoing on your MaxDate.

I hope this will help you

Regards,

Kaushik Solanki

Max Date Values not showing in Report

Fri, 27 May 2011 10:33:08 GMT

i did not understand above issue....

how do i solve this problem any idea???

Regards,

Napolean.

Max Date Values not showing in Report

Fri, 27 May 2011 10:34:51 GMT

Hi,

i tried below set analysis, its not working

Sum({$<Date = {$(#MaxDate)}>}remainingOutgoing)

Max Date Values not showing in Report

kaushiknsolanki — Fri, 27 May 2011 10:35:58 GMT

Hi,

Can you tell me what data you want in Total.

Regards,

Kaushik Solanki

Max Date Values not showing in Report

Fri, 27 May 2011 10:49:13 GMT

Hi,

I need Outstanding Amount + Remaining Outgoing (value will be max Date).

Following out put i need on the report without selecting the following customer no.

Please check customer No. C00003 - -0.37

C000015 - -0.14

C000017 - -0.73

Max Date Values not showing in Report

Fri, 27 May 2011 11:40:46 GMT

Hi,

Got any idea...

Re: Max Date Values not showing in Report

llauses243 — Mon, 30 May 2011 17:21:44 GMT

Hi Antony,

This is my offer, pls see .rar

Good luck, Luis