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.
Hi Guys i have the attached scenario and i need a quick solution, i have given the excel example in the attached.
I have a group of records. 1 record has multiple lines identifing the types so the record ID repeats for every Type and Oper see attached.
i want to count the reordID which contains type of F and Oper=0010 which is straight forward
i then want to count the records ID that contains a line where Type =F and Oper=0010 and also contains type =X on any line where Oper>0010.
Any replies/samples would be appreciated
You just need to add more operators to your condition : "or" (with brackets) and "and".
If( (Type = 'F' and Oper = '0010') or (Type = 'X' and Oper > '0010'), 1)
Because of large volumes, my solution was create a resident load with a flag for the first part of the logic and join it back on the original table and use set analysis to work out the 2nd Count. its now working fine.