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.
I have a data table:
Could hepl me tyo find out, what should be an expresion to select Saifi value, for each ID, where duration is more then 0,05 and has max customer number. Dimension is Time.
The result table should be like this:
As per the expected output
Create a Pivot /Straight table
Dimensions are: Time,ID,Duration,Customer Number
check this once & correct me if i understood wrongly
View solution in original post
This seems more easily doable if ID was the dimension and Time was one of the expression... would you be able to provide the Excel file with the data so that we can load that instead of hand typing everything to create a sample.
There is my file.
Ok, lets try if ID is dimension.
Not looking for an image file, but an Excel file
as you suggestion works fine, but I still need to do not include Duration dimension where it is less then 0.05.
Time dimension is created as calendar group (time, week, month...), so if I choose the month, it shows all rows separately, but I need the SAIFI sum for this time period.
could you help me 🙂
Thank you! It works.