Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

Sheet Trigger using variable - Qlik Sense

Hey Community,

 

I am trying to create a sheet trigger that will apply a filter using a variable that I have created (either from the load script or created on the front end). The variable 'vLast6Months' (shown below) calculates the last 6 months and sets a date field column to those values:

='(' &date(AddMonths(monthstart(today()),-5),'MMM-YY')& '|' &date(AddMonths(monthstart(today()),-4),'MMM-YY')& '|' &date(AddMonths(monthstart(today()),-3),'MMM-YY') & '|' &date(AddMonths(monthstart(today()),-2),'MMM-YY') & '|' &date(AddMonths(monthstart(today()),-1),'MMM-YY') & '|' &date(AddMonths(monthstart(now()),0),'MMM-YY')&')'

I have confirmed the variable is working as expected and can be applied via a button click, but for some reason it is not working when I try doing the same thing using a sheet trigger. Here is a screenshot of what I have applied for the sheet trigger:

rbrooks_0-1588109566350.png

 

Has anyone gotten this to work?

Labels (2)
2 Replies
Highlighted
Employee
Employee

Try using the Dollar sign expansion

=$(vLast6Months)

Highlighted
Partner
Partner

Hi Lisa,

I tried using =$(vLast6Months) but that did not work. Does it make a difference if I create the variable in the load script vs the front end?

Thanks