Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
smilingjohn
Specialist
Specialist

Comparision

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.

1 Solution

Accepted Solutions
pradosh_thakur
Master II
Master II

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

Learning never stops.

View solution in original post

6 Replies
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
Specialist
Specialist
Author

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
Master II
Master II

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

Learning never stops.
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
Specialist
Specialist
Author

Hi Pradosh ..

Thanks bro ...

This is what i wanted ....

How did you excluded the PDLoad Filter ?

can you please tell me

pradosh_thakur
Master II
Master II

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

Learning never stops.