Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good day all.
I have a situation that i am unable to figure out. Where normal requests and queries are ok.. I struggle with a certain string of items i need from data with IF and When, however i am not understanding how the Qlik language and syntax works. Is there anyone whom i can send a file to or upload here so i can explain what i am trying to achieve?
I actually added a file.. what i need to do is the following ( this is just 1 day's items, but the idea would be working on date.. so unique values per day is needed from this.
1 - for each unique user id i need a count of the transaction types per day.
2 - for each unique user id i need the first entry date/time and the last for each day to show in total hours for each day.
3 - If the first entry date and the last entry date = more than 9 hours, I need this to stand out and then the amount of time spent over 9 hours needs to reflect as well as the count per transaction type for each individual user per for that amount of time.
Kind regards
G
Hi Gerhard,
Believing that the chart will be in the a table, it may be something like this (if I understand you correctly)
1) Dimension: UserID
Expression: Aggr(Count (TransactionType), UserID)
2) Dimension: UserID
Expression: Time(Max(Timestamp#(Time, 'DD/MM/YYYY hh:mm:ss')) - Min(Timestamp#(Time, 'DD/MM/YYYY hh:mm:ss')))
3) Please give us an example, that you want to see the result?
Regards,
Andrey
Than you so much Andrey..
I will give it a shot and let you know..
Much appreciated
Regard
Gerhard
I'll also thereafter show what i want as an end result.
Hello Gerhard,
Hope you are doing well!
Based on your requirement I have created a sample application. Please review and let me know if it works or not.
Thank you!
Rahul