topic Re: Using Set Analysis for date comparison as expression in QlikView

Using Set Analysis for date comparison as expression

Fri, 19 Oct 2012 09:50:03 GMT

Hello,

I am developing a simple table in qlikview .the dimension for table named "customer_payment "its fields are "customername", "duedate","dueamt","paiddate","paidamt".

i am trying to design a simple pivot table which show the sum of all those customers who have paid thier dues the same day as thier duedate.

I am currently using set analysis ie

sum({<duedate={"=paiddate "}>}paidamt )

for finding the sum of payment on the same day but its not working .

I also tried the "if()" condition like -

sum( if(duedate=paiddate,paidamt,0)

this expression seems to work but i was wondering if the same result can be achieved throught Set Analysis .

I am attaching a demo application

Thanks and Regards ,

s_tushar

Re: Using Set Analysis for date comparison as expression

Fri, 19 Oct 2012 10:15:45 GMT

You can make it like that ;

sum({< duedate=p(paiddate) >}paidamt )

Re: Using Set Analysis for date comparison as expression

Sat, 20 Oct 2012 04:57:20 GMT

Thanks

Re: Using Set Analysis for date comparison as expression

sagarpithadia — Tue, 04 Nov 2014 06:25:28 GMT

can you elaborate what this function P() do ?

Re: Using Set Analysis for date comparison as expression

suresh_rawat — Tue, 04 Nov 2014 06:32:24 GMT

Hi,

P() function is used to show the possible result for the expression.

In you example P shows, all possible paiddate is equivalent to duedate then it shows the paidamount

Regards

Suresh Rawat

Re: Using Set Analysis for date comparison as expression

suresh_rawat — Tue, 04 Nov 2014 06:33:34 GMT

Also instead of P we use E function then it shows the paidamound based on all the duedate is not equal to the paiddate.

Re: Using Set Analysis for date comparison as expression

ashfaq_haseeb — Tue, 04 Nov 2014 06:36:38 GMT

Hi,

Check this too.

http://community.qlik.com/docs/DOC-4951

Regards

ASHFAQ