Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
mgordon2
Contributor
Contributor

Specifying Data to be Displayed when Button is Pressed

Hey everyone! 

SQL-Heavy user here, trying to use this janked up syntax thing of a program y'all call QlikView.  I have a chart which displays information regarding users for a Salesforce-like database.  I have a column with their last login date.  I also have a column where it calculates DAYS SINCE LAST LOGIN.  It ranges from 0 to 900.  

>>> I'm trying to create buttons on the left/selection side that when clicked display just users with <30 days, as well as 31-60 days, and 61+ days.  It doesn't have to be buttons it can be anything!  I just don't know how to specify the syntax or anything.  To get the DAYS SINCE LAST LOGIN calculation, it's 

= Round(Today()-[Last Login])

Help me make these buttons!!!   The syntax QV uses for expressions is beyond wild!  

Labels (6)
1 Reply
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

Welcome to the QlikView world. Easiest and most powerful approach is create a new field in the data when loading. 

=Round(Today()-[Last Login]) as [Days Since Last Login]

You can then create a listbox on the sheet with field [Days Since Last Login] and the user can select whatever values they want, including using expressions like >31 when they make the selection. 

If you want to provide a grouped field like "<30", "30-60" and so on, use an if() function in the script like so:

if(Today()-[Last Login]) >60, '61+ days'
,if(Today()-[Last Login]) >30, '31-60+ days'
,'<30 days')) as  [Days Since Last Login]

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com