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:
Buckets
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)
Provide any sample data.
i cant acheive these how to do this
exapmle:
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])
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
