Hi all!

I have recently started working on Qlikview so have less knowledge about it. The task I am trying to achieve is calculate the Loan Amortization Schedule using the while loop but could able to do that.

I have following input table(qvd) 

I want Loan Amortization Schedule to be calculate in qvs using the Qvd I have up pasted meaning I want separate table for the Payment plan based on this inputs.

the desired result show be like that, this picture is random loan calculation 

will greatfull if somebody can help. 

Hello everyone, 

I want a line chart with a cumulative count in my Qlik Sense App. So, what I have done is this expression : 

Aggr(
RangeSum(
Above(COUNT ( VEHICULE_NUMBER ), 0, RowNo())
)
,[Date]
)

In the dimension, I have a date. 

Although, for some date, I don't have VEHICULE_NUMBER so, the line chart is not continous, it has blanks.

What I want here, is that instead of the null value, to pick up the last value of my count which was not null. For exemple in my line chart I have : 

I tried to simplify my count here for you to understand the problem, but the set analysis is huge and contains many conditions. 

Do you have any suggestions ? 

I tried to take the value "above" but in my example, it fulled only the line 2016 and not the 2017. I need it to take the last not null count. 

Thanks !

Configuring a MSSQL source connection for Qlik Replicate. The instruction specify,

In the Distributor step, select <Microsoft SQL Server Name> will act as its own distributor; Microsoft SQL Server will create a distribution database and log.

First assumption is that if the databases is already using MSSQL Replication and a distribution DB this can be skipped.

Will Replicate properly if this distribution database is a remote server and NOT local to the datasource?

I am facing issue when connecting to postgreSQL endpoint

Task cannot be started because source endpoint 'ep_postgre_src_mss' of type 'PostgreSQL' has no license.

Hello Team,

I want to create a table like below which is having some dimension and some measure but that measure are having two different  headers, I am not getting how can i achieve this, can someone please guide me here.

I tried something like below, created one inline table and added the two columns in pivot table column

Header:
Load * Inline
[

Header 1 , Header 2

Header 1 , Sub Header 1

Header 1 , Sub Header 2

Header 1 , Sub Header 3

Header 12, Sub Header 1

.

.

Header 2 , Sub Header 5

];

But this is not working as shown in the image above, please help me to resolve this issue.

Thanks and Regards

Aslam Shaikh

Hi all,

I am needing to count distinct account_num but from three different tables but I also need to exclude the count if they appear in another table. I have been using P() for those that match up, but I am having issues on count distinct excluding those in common.

For example: table1 = new customer, table2 = existing customer, table3 = lost customers. 

count({<Table3_account_num=P(table1_account_num), table3_account_num=-P(table2_account_num)>}distinct table3_account_num)

I put a '-' before the P because E() was returning zero and thought at a strech this might work, which it doesn't. 

I should mention all my tables are separate, they are linked by any key. 

essential I want to say, count distinct all account_nums that are in table 3 that are also in table1, but if an account_num is in table 2 then ignore it from the count. 

Any help would be great,

Hi!

I come to you with a request to suggest an idea for solving the problem.

I have a sales table as in the attachment. It has more data, of course, but this is what it looks like.

How (at the load editor level) to mark customers who have bought on ONE INVOICE:

- a selected set of products (e.g. 'HZJFNNZH' and 'QHUXWGTW'),

- minimum x pieces (where x is also fixed), eg. 'HZJFNNZH'> = 5 and 'QHUXWGTW'> = 10.

Of course, there may also be other products on the invoice.

Thanks for any suggestions!

Hello!

I'm having trouble with this table:

I used the following formula so in the first column, the numbers underlined in red calculate the average of the numbers to their right instead of showing the sum, and the totals of every column show the sum of their numbers below:

if(Dimensionality()=0,
sum((calificacionM/100)*porcentaje),
avg(aggr(sum((calificacionM/100)*porcentaje), [MESAÑO_CON], nombreClasificaciones, num_porcentaje)))

What I'm having trouble with is that I need the number highlighted in yellow to sum the numbers below, not the numbers to its right, so I can have 96.75 instead of 967.48.

Any ideas? Is it possible? Thanks so much for your help!!

I'm having an issue with this. I'm trying to get the MPG for both units, but it only shows the first unit's gallons for the total.

=Sum(LOADED_MILES+DEADHEAD_MILES+TOLL_MILES)/If(Sum(TRACTOR_GALLONS)>0,Sum(TRACTOR_GALLONS),Sum([T.Fuel Gallons]))

Hey guys,

I have a table with Dates and Values that contains future dates with empty values. I need to fill these null values with an average of the last 3 values, ordered by date. Does anyone know how to do it?

E.g.:
Date, Value
19/01/2022, 3
20/01/2022, 6
21/01/2022, 9
22/01/2022, -
23/01/2022, -
24/01/2022, -

...

Should be:
Date, Value
19/01/2022, 3
20/01/2022, 6
21/01/2022, 9
22/01/2022, 6 (3+6+9)
23/01/2022, 7 (6+9+6)
24/01/2022, 7.333 (7+6+9)

...

Thanks in advance!