Hello,

I have a line chart in which I want to display a specific number for each week of this year. For this I have the dimension "Created-Date_Week". In my data, I currently have weeks of this year up to week 17, but I want the x-axis up to week 30.

Is it possible to extend the x-axis to week 30, even if I only have data up to week 17?

Thanks and best regards!

when we are trying for CDC Load for ODBC connection the job is getting failed with below errors.

Error 1: 

Stream component 'st_0_QAD_PERU' terminated
Cannot initialize subtask
Failed while preparing stream component 'st_0_QAD_PERU'.
Failed to prepare sqlite statements for CAPTURE MODE
Failed to prepare statement - select confirmed_ctx from confirmations where table_id=? -  
SQLite general error. Code <1>, Message <no such table: confirmations>.

Error 2 :

Stream component 'st_0_QAD_PERU' terminated
Stream component failed at subtask 0, component st_0_QAD_PERU
Error executing command
Failed to init cdc table table 1
Unable to get column_def for context Field 0 of table 1

Attaching the logs for both Error

All,
I am new to Qlik and wondering if this is possible to acheive in qlik sense.
Requirement:

sum consecutive rows in a pivot table and add it as another/new row.

Please see the attached for sample data reference.

For example in the attached qvf .. i want to sum MMR + NAT i.e 10000+670 and add the sum 10670 as a new row below it .

MMR

NAT
MMR+NAT
PC
TAR
ULP

I want to do this for multiple rows and the data set will be static data set .

Please let know if the requirement is not clear, appreciate any help or guidance on this.

Thank you,
RV

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!

Hello

Can anyone suggest how to get this ?

In Qliksense VizLib Line Chart, we can display the negative values in red color where as with Qlik Native Line Chart,there is no provision to display the negative values in red color , Something Like Below

hi,

i have 2 tables 

1 with budget

and 1 with invoices

now i want to do a flag in the dashboard that say if sum invoice > budget , 1 else 0

and show only the drivers and spent more then their budget

i tried to do master item with dimension but its not giving me 1 OR 0 

if i do it in measure its give me 1 OR 0 

but then i cant filter it in the table i show in dashboard

please help me if you know a solution or have any other idea

🙂