Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
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))
Thanks. and simply add the next parameter which allows you to supply default val if condition fails (or whats equiv to an 'else').
That still shows a list of users who have used ❤️ login passes.
Would you be able to share a sample to check this out?
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.
Here's a copy of the app; go to the last sheet for the table I'm working on. Thanks for looking.
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))
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?