Hi, I would like to calculate rolling sum like in the table below. Data should be grouped by column "Family". For each quarter I want to take a look at current quarter and 2 quarters backwards. Any idea how to achieve this in script editor? I am not interested in set analysis using rangesum - above combination. Column "Quarter" comes from fiscal master calendar.

Thank you.

I have dataset like this

and I want a new field ItemGroup where is the group item of each line that it belongs too. 

So I basically want to add the itemcode (example Gitem1) of the LineType "group" to new field ItemGroup

to all the fields with the same TranID as long as LineType "endgroup" is reached. After that the next group's itemCode is added to the next lines to ItemGroup -field

Hi Team,

I have developed an UI that is using highchart for graphs and getting data through hypercubes.

Everything is working fine except data filters that is getting passed from UI.

I have 10+ filters and except date filters everything working as expected.

Can any expert help me out here:
Code:

------------------------------------------------------------------------------------------
async onSelectSingleDate(date){
const myDate = moment(date).format("YYYY-MM-DD");
console.log('myDate', myDate);
//create the expression - the result from this expression gets the values that are between the selected dates
const dateExpression = `=Concat({<[Bookings Date]={"${myDate}"}>} distinct [Bookings Date],',')`
console.log('dateExpression', dateExpression);
//evaluate expression to get the selected dates
const expressionResult = await this.qlikService.evaluateExpression(dateExpression);
console.log('expressionResult', expressionResult);
// collect the values to select
const selectedValues = [{qText: expressionResult, qIsNumeric: true, qNumber: new QSDate(moment(expressionResult)).getIntegerValue() }];
console.log('selectedValues', selectedValues);
//apply values
await this.qlikService.selectMultipleValuesPerField('Bookings Date', selectedValues);
//refresh data
await this.refreshData();
}

Hi, 

A customer of mine is requesting automated Excel reporting to Dropbox according to a particular template. However, I cannot seem to find a solution. 

The customer wants a Excel report based on a table in the dashboard. Some changes need to be made, that we cannot include in the table in the dashboard. Therefore, we need a template in Excel, like in Tabular reporting. However, then we cannot distribute the report to a Dropbox folder. Due to the fact that we need to use Excel, application automation is not possible. 

Does anyone know how to achieve this? 

kind regards, 

Sterre

Hi,

I have a date and time field. I want to convert the field to MonthYear and use it in a line chart. I used the expression below but the line chart is not showing the monthyear as expected. Can anyone help please. Thank you. 

LOAD
"Submission Date",
date(MonthStart(date#([Submission Date], 'DD/MM/YYYY hh:mm')), 'MMM-YYYY') as MonthYearEX,

Hello!

We have QlikSense on prem; at the authentication level, we would like to connect a website where users authenticate using Office365 accounts, to the QlikSense application.

I'll try to explain our need: we have a website; users authenticate with their Office365 accounts. They exists also on QlikSense in the users list because the list is automatically updated every day. I want that when a user log in into the website, he is authenticated also on QlikSense. 

How can I accomplish this?

I tried to explore the solutions in the documentation, bot got lost.

Thank you

Hi there 🙂

I have a list of products with list prices and different valid-from dates to this prices. Now I simply want to show only the newest valid-from dates (one per product). Thats it 😄 

Coud you please help me out with the script function. Attached you find the table load.

Thanks a lot!
Pesche

I need to modify an existing P&L table with several scenarios (using the Vizlib solution with external Excel table).

Is it possible in a P&L table to use different factors per line?

sum(  Value* $(=PL_View_Factor_Best) )

I get the right calculation, when the factor is the same for all lines, but when using different values or even a conditional value for different scenarios, it returns no value.

Is there another/better way to solve this?

I need to export data from a straight table as a CSV file without BOM and semicolon formatted. 

In other cases I have been running a vb script that exports data, but I havne't been able to find the one mentioned above.

I also have another request,which is to add one first line with a fixed text. Any suggestions.

We are using QlikView 12.60

/John