topic Re: interval in the coding in QlikView

interval in the coding

manoranjan_d — Tue, 08 Nov 2016 10:10:04 GMT

hi all,

i need the interval like below

No of times user logged.

Eg - No of times No of Users

0 10

1-5 20

6-10 30

11-20 40

21-40 15

>41 5

i tried

LOAD

[user name],

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

Resident Main

Group By [user name];

but its not good its howing more interval i need the example interval till >41 is fine. how to do this?

Re: interval in the coding

Gysbert_Wassenaar — Tue, 08 Nov 2016 10:14:52 GMT

Perhaps like this:

LOAD

[user name],

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

Resident Main

Group By [user name];

Re: interval in the coding

Aurelien_Martinez — Tue, 08 Nov 2016 10:17:33 GMT

Hi,

You can use Intervalmatch function.

LOAD

[user name],

Count([login details]) as LoginCount

Resident Main

Group By [user name];

_temp:

Load * Inline [

interName, Min, Max

0, 0, 0

1-5, 1, 5

];

intervalmatch(LoginCount)

Load

Min

Max

resident _temp

;

Re: interval in the coding

manoranjan_d — Tue, 08 Nov 2016 10:54:19 GMT

hi gysbert now i want to sort this interval in the bar chart? how to do this?

example:

in bar chart i have used the login as dimension and count(username) as exprseion

now this dimension has to be in proper sort orderof interval form 0 to >40

Re: interval in the coding

Gysbert_Wassenaar — Tue, 08 Nov 2016 11:10:14 GMT

Change the line to:

If(Count([login details])>40, dual('>40',41) , Replace( Class (Count([login details]),10),'<= x <','-')) as Login

That way you can sort Login numerically