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 below table
I am trying to identify transactions where the same ID was used more than once in a day. In the above example, I expect to have the output as
Can you please let me know the expressions I need to use to achieve the same?
In the script you can do something like this:
LOAD [Transaction ID],
[Transaction ID] & [Transaction Date] as Key
Count(DISTINCT Key) as Count
Group By Key;
View solution in original post
Create a Straight Table
COUNT(Distinct [Transaction ID])
Another approach would be:
count(1) as TransactionCount
Group by [Transaction ID], [Transaction Date]