topic Re: Need assistance with formula in App Development

Need assistance with formula

Anonymous — Wed, 08 Feb 2017 06:53:17 GMT

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

Re: Need assistance with formula

ahaahaaha — Thu, 09 Feb 2017 07:01:35 GMT

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

Re: Need assistance with formula

Anonymous — Thu, 09 Feb 2017 07:10:12 GMT

Than you so much Andrey..

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

Much appreciated

Regard

Gerhard

Re: Need assistance with formula

Anonymous — Thu, 09 Feb 2017 07:10:53 GMT

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

Re: Need assistance with formula

rahulpawarb — Thu, 09 Feb 2017 10:12:54 GMT

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