Comparision

[smilingjohn]

Hi All,

Please find the attachment of the QVW File .

I have two table ..and one filter called PD Load Date ,

1.The first table which at the top should show the value according to the dates selected in the PDLoadDate.

And the below table should show the values For Max of PDLoadDate ..and it tshould exclude the Selections of PDLoadDate Filter.

2.Whatever the date i select in the PDLOadDate Filter , the Top Table shows the vlaue accordingly ..

and the vlaues will differ from second table and all the changes in the second table should be marked in the Red Colour ..

Please help me Expertise ..

Thanks in Advance.

[avinashelite]

Couple of questions

1."below table should show the values For Max of PDLoadDate ..and it tshould exclude the Selections of PDLoadDate Filter". What this mean ?? you have 2 dates 10 and 9 if i select 10 then it will be max and it eliminate that selection means not records should show ???

2."the vlaues will differ from second table and all the changes in the second table should be marked in the Red Colour"

What is the logic for this ? how to identify the diff

[smilingjohn]

Hi Avinash,

Means always the below chart should diplay the data for Max PDLoadDate.

And the above Table should display the values according to selection made in the Filter PDloadDate...

If you select 9 th in th PdLoadDate then the values will  shoow on that day only ..

and accordingly i want to see in the second table that ..if open ,closed or Totalopen ..are the same or not ..

if not same the it should highlight the cell with red colour ..

[pradosh_thakur · Accepted solution]

Hi john

please find the attached. About the color part i am not sure that is what exactly you meant. If i understood correctly then good else let me know the requirement again .

regards

Pradosh

[avinashelite]

Use this set analysis expression

>=$(=Date(Max({1}PDLoadDate) in call the expression to in Second table to get the max date .Other part of the requiremetn I am not clear

[smilingjohn]

Hi Pradosh ..

Thanks bro ...

This is what i wanted ....

How did you excluded the PDLoad Filter ?

can you please tell me

[pradosh_thakur]

Hi

i changed your expression to

Sum({$<PDLoadDate={"$(=Date(Max({1}PDLoadDate), 'DD-MM-YYYY'))"}>}PDOpenCount)

(max{1}PDLoadDate) will always select the maximum date and will ignore the selection in that filter. so below table will always show for maximum date

about the color part i just compared the current selection with max and if not same red(). You can check the background color of each expression .

Let me know if you need anything. If satisfied close the thread by marking helpful and correct.

Happy to help!

regards

Pradosh