...hat feature of nesting variable to deal with more neat expressions where I want use predefined variables with filters and so on, but there are many commas and it's turned so that I can't write really c...
hi all, im new to qlik, im pulling in the filetime() of my xlsx files, i want to compare that vs the "now()" time and if the filetime() is greater than 10 minutes old, the script will fail, what i...
...orkaround for dollar sign expansion with parameters ) but can't make it work. Furthermore, I have stored most of my set analysis in variables so that I have a variable vSetAna1 that looks like u...
...ax value in variable and apply grater than (>) condition in that variable in where clause as per steps in incremental load. lastupdateddate: load timestamp(max( Op_date_time,'DD-MM-YYYY h...
Hi Gurus, I am now writing a variable as the expression for the dashborard that containg parameter as the set analysis modifier.: sum({<CalendarDate={">=$(vCurrentMinDate) <=$(v...
Is there a way to put multiple string in a single parameter ? For eg: Expression: Let vE_Sales = sum({<Year = {$1}>} Sales); When calling this expression we say $(vE_Sales('2016')) B...
...elow:
But if I am trying to include more parameters in the expression, its throwing an error, as per below:
I guess comma is causing the issue here, but how to fix it, I am not sure. I t...
I've created a custom variable that accepts a date parameter and returns a value. It works as expected when a date is passed through to the function, but doesn't work when a function is passed t...
Hi all, I did found the following thread (Set Analysis - how to use variables inside set ... | Qlik Community) which deals with the problem I have. Unfortunately, I could not figure out how i...
