topic hard code in QlikView

hard code

manoranjan_d — Mon, 07 Nov 2016 12:12:11 GMT

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?

Re: hard code

its_anandrjs — Mon, 07 Nov 2016 12:16:34 GMT

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

Regards

Anand

Re: hard code

sunny_talwar — Mon, 07 Nov 2016 12:17:42 GMT

You can also look here:

Buckets

Re: hard code

manoranjan_d — Mon, 07 Nov 2016 12:23:49 GMT

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?

Re: hard code

sunny_talwar — Mon, 07 Nov 2016 12:27:38 GMT

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

Re: hard code

its_anandrjs — Mon, 07 Nov 2016 12:28:42 GMT

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

Re: hard code

its_anandrjs — Mon, 07 Nov 2016 12:30:45 GMT

Provide any sample data.

Regards

Anand

Re: hard code

manoranjan_d — Mon, 07 Nov 2016 12:55:07 GMT

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?

Re: hard code

its_anandrjs — Mon, 07 Nov 2016 13:04:54 GMT

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

Re: hard code

manoranjan_d — Mon, 07 Nov 2016 13:26:43 GMT

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

Re: hard code

its_anandrjs — Mon, 07 Nov 2016 13:42:21 GMT

Hi,

Then check this attached one with both

1. In the Calculated dimension with class function

2. With Class function in the script level

Main:

LOAD [user name],

[login details]

FROM

[..\..\Documents\UserData.xlsx]

(ooxml, embedded labels, table is Sheet1);

Query:

LOAD

[user name],

Replace( Class (Count([login details]),10),'<= x <','-') as Login

Resident Main

Group By [user name];

Regards,

Anand

Re: hard code

manoranjan_d — Mon, 07 Nov 2016 14:28:13 GMT

we cant achieve these in the calculated dimesnion?