Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have a data set below in excel and i would like to get the Total based on the Payment Status displayed in Qlik View through a pivot.
Sales Number | Personnel | Sales Amt | Payment Status | Total |
AAAAA | Ankle | 75 | Paid | 75 |
BBBBB | Arm | 50 | Due | 50 |
CCCCC | Hand | 24 | Paid | 24 |
DDDDD | Fin | 20 | Paid | 20 |
EEEEEE | Plank | 30 | Due | 30 |
FFFFF | Hill | 45 | Due | 45 |
I have attached the QlikView Output which I am unable to get the Total in a new column on its own on the extreme right. Is there anyway I am doing it wrong?
You want like this???
Hi,
May be as in attached file. You can use flag "Show partial sums"
Regards,
Andrey
Check the attachment, if you are looking r something like this.
Thanks,
I am unable to open forums qvw. Are you able to give a brief screen shot or the formula ?
Thanks
I am unable to open qvw attachments in forums, are you able to provide the screen shot or formula?
Thanks Andrey..
It worked..appreciate it