hard code

[manoranjan_d]

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?

[its_anandrjs]

Use Class function or may be create the Buckets by using if condition in script level.

Regards

Anand

[sunny_talwar]

You can also look here:

Buckets

[manoranjan_d]

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?

[sunny_talwar]

It should be just replacing the ShippedDate - RequiredDate with Count(Logins) or Count(UserName)

[its_anandrjs]

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

[its_anandrjs]

Provide any sample data.

Regards

Anand

[manoranjan_d]

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?

[its_anandrjs]

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

[manoranjan_d]

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