topic Re: Specifying Data to be Displayed when Button is Pressed in QlikView

Specifying Data to be Displayed when Button is Pressed

mgordon2 — Sat, 16 Nov 2024 21:27:30 GMT

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!

Re: Specifying Data to be Displayed when Button is Pressed

rwunderlich — Wed, 06 Feb 2019 22:31:26 GMT

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