This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
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
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.
please post some sample data and your expected result
Hello again i dont want to change the raw data...
so i want in this script a sum of (scrap, reworking & accepted) as total.
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.
Okay how i will add a new field of those 3 types?
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.
Yes, this is possible.Please post some values and your expected result.
Hello i am afraid i can't share data..it is not possible to write the equation without them?
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.