topic Re: Using a value condition for Set Analysis in App Development

Using a value condition for Set Analysis

mikegrattan — Sat, 16 Nov 2024 06:59:45 GMT

I have a Set Analysis expression that gives me a count of login passes by user for the current day. I'd like to filter it so it only shows when the count >3. Can someone point me in the right direction?

Count({<[Access Type]={'Login Access'},LogTimeStamp= {">=$(=daystart(today())-0)"}>} distinct UsageId)

Re: Using a value condition for Set Analysis

sunny_talwar — Thu, 20 Dec 2018 17:20:17 GMT

May be just this

If(Count({<[Access Type] = {'Login Access'}, LogTimeStamp = {">=$(=DayStart(Today()) - 0)"}>} DISTINCT UsageId) > 3,
Count({<[Access Type] = {'Login Access'}, LogTimeStamp = {">=$(=DayStart(Today()) - 0)"}>} DISTINCT UsageId))

Re: Using a value condition for Set Analysis

Anonymous — Thu, 20 Dec 2018 17:43:45 GMT

Thanks. and simply add the next parameter which allows you to supply default val if condition fails (or whats equiv to an 'else').

Re: Using a value condition for Set Analysis

mikegrattan — Thu, 20 Dec 2018 18:15:56 GMT

That still shows a list of users who have used ❤️ login passes.

Re: Using a value condition for Set Analysis

sunny_talwar — Thu, 20 Dec 2018 18:21:58 GMT

Would you be able to share a sample to check this out?

Re: Using a value condition for Set Analysis

mikegrattan — Thu, 20 Dec 2018 20:30:10 GMT

I'm using the License Monitor application in Qlik Sense Enterprise. I just added a new sheet with a table and the following fields:

User Name
LogTimeStamp
Access Type
Count of access passes used today if count > 3 (set analysis expression)

The goal is to show in this table only those users who have used more than 3 login access passes today.

If you need a copy of the app let me know and I can attach it to the question.

Re: Using a value condition for Set Analysis

sunny_talwar — Thu, 20 Dec 2018 20:46:50 GMT

I think sample file would help me understand this. Make sure to zip the file before you attach because this new community doesn't allow to attach .qvf file without zipping it.

Re: Using a value condition for Set Analysis

mikegrattan — Thu, 20 Dec 2018 21:43:00 GMT

Here's a copy of the app; go to the last sheet for the table I'm working on. Thanks for looking.

Re: Using a value condition for Set Analysis

rohitraut — Fri, 21 Dec 2018 07:15:05 GMT

hii,

try this,

if(Count({<[Access Type] = {'Login Access'}, LogTimeStamp = {">=$(=date(DayStart(Today()) - 0,'YYYY-MM-DD hh:mm:ss'))"}>} DISTINCT UsageId)>3,

Count({<[Access Type] = {'Login Access'}, LogTimeStamp = {">=$(=date(DayStart(Today()) - 0,'YYYY-MM-DD hh:mm:ss'))"}>} DISTINCT UsageId))

Re: Using a value condition for Set Analysis

sunny_talwar — Fri, 21 Dec 2018 12:54:14 GMT

Are you looking to see only those Users who have logged in more than 3 times? May be try this

Count({<[Access Type] = {'Login Access'},
	LogTimeStamp = {">=$(=Date(Today(), 'YYYY-MM-DD hh:mm:ss'))"},
        UsageId = {"=Count({<[Access Type] = {'Login Access'}, LogTimeStamp = {[>=$(=Date(Today()-1, 'YYYY-MM-DD hh:mm:ss'))]}>} DISTINCT UsageId) > 3"}>
      } DISTINCT UsageId)

or are you looking to see the table only if the total number of rows in the table is more than 3?

Re: Using a value condition for Set Analysis

mikegrattan — Thu, 27 Dec 2018 14:43:37 GMT

I want to show only those users who have used 3 or more login passes for the current day. I will try your expression and see how it works today. Thank you.