Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
isciberras
Creator
Creator

Help with expression

Hi,

I am currently in the process of creating a password analysis dashboard and I have a question with regards to creating an expression which I could use to quantify users and their failed login attempts.

I managed to get the answer I need from a chart I created (I attached pictures of the chart), however I am finding it difficult to write an expression which will produce the same result. 

Basically I am trying to quantify the amount of users which had 2 failed loagin attempts more than 3 times.  The expression in my graph is COUNT(Failed_Attempts) and my dimension is Failed attempts, USER and DATE [I am using a drill down group]

Does anyone have an idea if I can create an expression to do this? So far I tried =aggr(Count(Failed_Attempts),TRAN_TYPE,USR) but this does not give me any result.

Thanks,

Isaac

(The attached image(001) shows the range of failed login attempts. image004 shows the number of times a user got 2 failed login attempts)

1 Solution

Accepted Solutions
sunny_talwar

May be this

=Sum(Aggr(If(Count({$<[Failed Attempt]={'2'}>}[Failed Attempt]) > 3, 1, 0),TRAN_TYPE,USR))

View solution in original post

4 Replies
Anil_Babu_Samineni

Can you use Sum(aggr(Count(Failed_Attempts),TRAN_TYPE,USR))

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
isciberras
Creator
Creator
Author

Hi Babu,


Thank you for your help, with your input I managed to refine the expression to get a correct answer. I now achieved the answer of the first graph I attached.

=sum(aggr(Count({$<[Failed Attempt]={'2'} >}[Failed Attempt]),TRAN_TYPE,USR))



The only issue with the result of this expression is that it brings back the count of all the failed logins with a second failed attempt even if they only had a failed login second attempt on one occurrence. I would now like to refine the syntax further to bring back only the count of failed attempts where the user had a second failed login on more than 3 occurrences.

Really appreciate your input on this.

Thanks,

Isaac

sunny_talwar

May be this

=Sum(Aggr(If(Count({$<[Failed Attempt]={'2'}>}[Failed Attempt]) > 3, 1, 0),TRAN_TYPE,USR))

isciberras
Creator
Creator
Author

You're a genius, code did exactly what I needed it to thank you  and I understood the logic, thank you