Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
how to hardcode the user logged in many times on a range
example
No of times user logged for particular month.
Eg - No of times No of Users
0 100
1-10 200
11-20 350
21-30 40
31-40 15
>41 5
how to achieve this in the script level?
and these data has to be shown in bar chart as no of times as dimension and no of user as expression?
Use Class function or may be create the Buckets by using if condition in script level.
Regards
Anand
You can also look here:
Hi sunny,
Thanks but how to calculate these buckets in the smple they have used the ShippedDate - RequiredDate
but coming to login details how can i do this?
It should be just replacing the ShippedDate - RequiredDate with Count(Logins) or Count(UserName)
On the application layer on the front end you can try this calculated dimension
Ex:-
Dim:-
Replace( class( Aggr(Count(Timestamp),Users,AppName),Aggr(Count(Timestamp),Users,AppName) ),'<= x <','-')
Expression:-
=Count(Timestamp)
Regards
Anand
Provide any sample data.
Regards
Anand
i cant acheive these how to do this
exapmle:
user name | login details |
1 | 11/7/2016 |
1 | 11/8/2016 |
1 | 11/9/2016 |
1 | 11/10/2016 |
1 | 11/11/2016 |
1 | 11/12/2016 |
2 | 11/7/2015 |
2 | 11/8/2015 |
2 | 11/9/2015 |
2 | 11/10/2015 |
2 | 11/11/2015 |
2 | 11/12/2015 |
2 | 11/13/2015 |
2 | 11/14/2015 |
2 | 11/15/2015 |
2 | 11/16/2015 |
thessis my sample data? how to fdo this sunny?
Check the attached Qlik file
Dim:- =Replace( class( Aggr(Count([login details]),[user name]),Aggr(Count([login details]),[user name]) ),'<= x <','-')
Expression:- =Count([login details])
Regards
Anand
but the details has to be started from a range based on below on the details
1-10
11-20
21-30
31-40
>41