topic Re: Comparision in QlikView

Comparision

smilingjohn — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: Comparision

avinashelite — Thu, 12 Oct 2017 07:11:09 GMT

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

Re: Comparision

smilingjohn — Thu, 12 Oct 2017 07:18:04 GMT

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 ..

Re: Comparision

pradosh_thakur — Thu, 12 Oct 2017 07:21:38 GMT

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

Re: Comparision

avinashelite — Thu, 12 Oct 2017 07:35:44 GMT

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

Re: Comparision

smilingjohn — Thu, 12 Oct 2017 07:36:47 GMT

Hi Pradosh ..

Thanks bro ...

This is what i wanted ....

How did you excluded the PDLoad Filter ?

can you please tell me

Re: Comparision

pradosh_thakur — Thu, 12 Oct 2017 07:42:29 GMT

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