topic Re: Script find total in QlikView

Script find total

cmano — Fri, 05 Nov 2021 16:05:00 GMT

Hello to all.

I am new to this so i need a little help.

I have the below script...how i will find the total values of scrap, reworking & accepted?

(i am gonna need it to calculate the percentage of each condition)

thanks in advance

Re: Script find total

AshutoshBhumkar — Fri, 05 Nov 2021 18:04:37 GMT

Hello,

Use Crosstable() to get all the Material Status(Blocked , Reworking, Accepted etc...) Into one single column.

And then you can use those values in set analysis to calculate the percentage.

Thanks,

Ashutosh

Re: Script find total

MarcoWedel — Fri, 05 Nov 2021 21:27:28 GMT

please post some sample data and your expected result

thanks

Marco

Re: Script find total

cmano — Sat, 06 Nov 2021 08:52:31 GMT

Hello again i dont want to change the raw data...

so i want in this script a sum of (scrap, reworking & accepted) as total.

any ideas?

Re: Script find total

AshutoshBhumkar — Sat, 06 Nov 2021 09:41:15 GMT

Hello,

I am not sure what exactly you are looking for. But is it something like you want to sum the values of scrap, reworking & accepted.

Take a straight table, add PO as Dimension.

And add measure as sum(scrap)+sum(reworking)+sum(accepted)

If you want to create a new field adding those three types, you will need to use Group by clause in script.

Thanks,

Ashutosh

Re: Script find total

cmano — Sat, 06 Nov 2021 09:51:04 GMT

Okay how i will add a new field of those 3 types?

Re: Script find total

cmano — Sat, 06 Nov 2021 10:39:44 GMT

Can i create in the script a new field which i will call it total to be the the sum of (scrap, reworking & accepted)?

Thanks in advanced.

Re: Script find total

MarcoWedel — Sat, 06 Nov 2021 21:00:17 GMT

Yes, this is possible.
Please post some values and your expected result.

Re: Script find total

cmano — Mon, 08 Nov 2021 06:54:16 GMT

Hello i am afraid i can't share data..it is not possible to write the equation without them?

Re: Script find total

MarcoWedel — Tue, 09 Nov 2021 20:06:10 GMT

It should not be confidential data of course.
Instead you could create some mock-up values and the result you would expect for those just to clarify your requirements and to create an example to test with.