Hi,

I'm working on financial KPI's and want to use the balance sheet as well as the P&L for analysis.

The differences is that in the balance sheet you have an ingoing balance and then the changes during the month is booked and then you get an outgoing balance, in my dataset there is no ingoing balances available from the database from any tables that I've found.

I want to to a rolling 12 months analysis on inventory turnover rate and need to be able to calculate averages for a twelve months period every month ending to get this KPI. 

I've added the ingoing balance for 2021-05-01 manually and concatenated with the transaction data, from this I can get an outgoing balance every month with RangeSum and Above where I've set period of times to 100000, (maybe there is a smarter way) which gives me the outgoing balance every month.

RangeSum(Above(Sum({<Sub_Group={'Inventory'}>}Amount),0,100000),)

How do I use this? I need to bring the value from 2021-05-01 to 2024-03-31 for example to be able to get my outgoing balance for 2024-03-31, see example below.

Is there a way to make a calculated field instead to use in set analysis or any other way that is more simple just shoot with ideas!

Help much appreciated, thanks!

Hi, I'm working with Qlik Sense SaaS using an OAuth2 connection to one of my tenants with Python3 in Ubuntu.

The handshake works fine and I'm able to hit the rest connector and get information about my managed spaces.

#Sending params to the API request
payload={'type':'managed'}
response = client.rest(path="/spaces", method="get",params=payload).json()
print(json.dumps(response, indent=4, separators=(". ", " = ")))

I've now tried creating a space. My code is as follows and fails with a bad request error:

payload={"name":"string","type":"shared","description":"string"}
response = client.rest(path="/spaces", method="post", params=payload)
print(response)

I'm hopeful it's a simple fix. The scope I'm using is admin_classic 

Any help would be appreciated!

I have a table with 100 columns

I want to check for column 1 = 'ID001' if the other 99 columns has a certain date value say '2025-01-01'

But my code is throwing the error fieldname not found in the for loop...

what i did

// first filter column 1 for ID001

[TEST]: NoConcatenate LOAD Distinct * Resident[MAIN_TABLE] where column1='ID001';

// Loop to check for date value =  '2025-01-01' if have flag as 1

For f = 1 to NoOfFields('TEST')
LET F1 = FieldName($(f), 'TEST');
[Fields]:
Load distinct FieldName($(f), 'TEST') as Field, If(Date(Floor($(F1)))=Date(Floor(' 2025-01-01')),1,null()) as check
AutoGenerate 1;
Next f
DROP Table[TEST];

Any idea how to solve? Thanks in advance!