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.
Below is my data structure
ID Status Amt
1 Active 234
1 Completed 211
2 Active 2000
3 Completed 400
If ID has Active and Completed count only ID with Active else count other status...
I want the below output
Thank you much.
Like this you want
i.e for ID = 1 you want only Active to be loaded as status in script?
Do you have any reference date column also?
This out put has 2 rows for ID 1..I only want Active ID if its both Active and Completed.