in order for me to "Count" those same ticket no. in table Getin and Getout, therefore i need to compare the value from
Table Getin, Table Getout, and Table Payment to obtain the same ticket number for generate the result like (Amount for the Ticket, Total paid ticket and total non-paid ticket.
In sql server i can create view to compare those value and field, but in qlikview i wonder how can it can achieve?
Thank you for time and i am still discovering the features of qlikview. Hope that i can learn in deep.
Yes. for the duplicate ticket in Payment table i would like to look for latest datatime instead...i read thru the table and those duplicate record is start with 0 and then number.
Because of the data source, it probably make me in trouble...
Legend :
- = null
0 = paid (Free of charge)
For example :
ticketNo Amount pdatetime
t1 0 4/27/11 3:00 PM
t1 3 4/27/11 3:01 PM
so i would to check for the greater time instead...
it seen i have long path for me to get friend with Qlikview...
