Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
You can make it like that ;
sum({< duedate=p(paiddate) >}paidamt )
BR
Thanks
can you elaborate what this function P() do ?
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
Also instead of P we use E function then it shows the paidamound based on all the duedate is not equal to the paiddate.