Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Need assistance with formula

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

4 Replies
ahaahaaha
Partner - Master
Partner - Master

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

Anonymous
Not applicable
Author

Than you so much Andrey..

I will give it a shot and let you know..

Much appreciated

Regard

Gerhard

Anonymous
Not applicable
Author

I'll also thereafter show what i want as an end result.

rahulpawarb
Specialist III
Specialist III

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