I am trying to split my quarter data into trailing 13 months and also the years, I am not sure how to do this. I have posted the original logic for the quarter data. So I need the columns 'Monthstart()' and 'Yearstart()' Please help!

Original formula for Quarter data column

=SUM(IF(QUARTERSTART(OT_Period)='10/01/2020',OT_Overtime_YTD))

The 'OT_Overtime_YTD' is the dollar amounts. Essentially the columns would be. 

Region/Location/Employee/Monthstart()/Yearstart()

We are trying to set up an action on sheet to 'select values in a field' - the action should be that when the sheet is opened the current 'Month-Year' is selected from the MonthYear field - but it does not currently work.

We are using the formula Date(Today(),'MMM-YYYY') to find today's Month-Year, this returns the value 'Mar-2021', and we can see that we have a value of 'Mar-2021' in our MonthYear field. When we close the app and reopen, or just navigate away from the sheet and then back to it, the selection is not applied.

We have tried replacing the formula with a hard-coded text string  of 'Mar-2021' and this also does not work.

Has anyone else experienced this issue in SaaS?

Hello,

In an effort to get a better understanding of variables, set analysis and $ expansion, I have a question:

In QlikView, I have this table:

I also have this variable:

vSalesSoFar = sum({< MonthNumber = {"<=$1"} >} ROW_COUNT)

 In a TextBox, when I enter this expression:

=$(vSalesSoFar(4))

I get the result, 700, as expected. It is summing Month Numbers that are less than or equal to 4.

In the table, when I add this expression:

=$(vSalesSoFar(MonthNumber))

I get 0.

❓My first question is: Why doesn't the expression see the MonthNumber as the parameter?

To check this, I changed the expression to actually enter a number, in the table:

=$(vSalesSoFar(4))

I get 700 on each row, which makes sense to me.

Then I created this variable:

vMonthPlus = $1 + 10

When I entered this expression in the table:

=$(vMonthPlus(MonthNumber))

I get the correct output on each row:

My second question is: What is the difference between the two variables that the MonthNumber is recognized in one (vMonthPlus) but not the other (vSalesSoFar)?

Thank you.

Hi,

Has anyone installed and configured Butler Tool from qlik garden to generate reload alerts?

https://community.qlik.com/t5/Qlik-Gallery/Ptarmigan-Labs-Butler-open-source-reload-alerts/ba-p/1799056

If yes, can you please let me know the steps you have followed for successful alert.

The documentation in Butler website is slightly confusing.

Thanks

I am looking for a method to only show data that comes from the last append date from my data source. My data looks like this:

[Current Date] | [Employee ID] | [Office]  | [Job Title]

01/01/2021       | John Adams     | Tokyo     | Sales

01/01/2021       | Mark Smith       | Chicago | Analytics

01/01/2021       | Dan Williams    | London  | Illustrator

01/01/2020       | John Adams     | Tokyo     | Sales

01/01/2020       | Mark Smith       | Chicago | Analytics

01/01/2020       | Dan Williams    | London  | Illustrator

01/01/2020       | Mary Carter       | Oxford    | Receptionist

01/01/2019       | Mark Smith       | Chicago | Analytics

01/01/2019       | Dan Williams    | London  | Illustrator

01/01/2019       | Mary Carter       | Oxford    | Receptionist

I want the final data to look like this in the app:

01/01/2021       | John Adams     | Tokyo     | Sales

01/01/2021       | Mark Smith       | Chicago | Analytics

01/01/2021       | Dan Williams    | London  | Illustrator

As you can see, I pulled all the data from the most recent data the was appended to my dataset. I need this to be an expression that I add to formulas for charts, tables, and KPIs - it cannot be a restriction in the data load editor (because the full dataset is used is a section of the app).

Does anyone have a formula or something that can help me do this?

Thank you!