Table 1:

Table 2:

Here my existing formula to calculate the total value based on table 1,

//company A,B,D >12MTHS

Sum({Table 2.Company-={'C'}
[> 24 MTHS]+[13-24 MTHS])

//company C >24MTHS
+Sum({<Table 2.Company={'C'},Table 2.Company -={'A', 'B', 'D'}>}
[> 24 MTHS])

Since table 1 may change, I want to change the measure dynamically, e.g if table 1 A aged ='>24MTHS', Change the formula measure to sum( [> 24 MTHS]).

Should I join table 1 and table 2 and then using if case to determine total MTHS value?

Is it a better way to calculate the total MTHS value based on table 1 column B?

Please help😥

Hi!

I searched for a solution but was not able to solve my problem.

I have a qlikview Report with revenues and i want to se the revenue for example: products , last 6 months revenue

Now i have this in a Formula for the summary of revenues:

sum({<[ArtikelTyp_name]={'Engine'},Date={'>$(=AddMonths(Max(Date),-12))'}>}[Rechnungsmenge])

also tryied

sum({<[ArtikelTyp_name]={'Light-Engine'},Date={'>$(=AddMonths(Today(),-5))'}>}[Rechnungsmenge])

If i change the Year from example 2021 and 2020 the result also changes but i want see the last 12 months from today regardless of selected year.

I tryied different things date(today) etc. but it wont work. I think "Date" is the problem?

Has anybody ideas whats wrong or whats the correct formular?

Thank you very much.

Hello,

I use Qlikview for long Time now, but now I experience a strang Issue:

when I create a new Object (e.g. Pivottable), I can choose the dimensions and add them, but after that step in the formula window I can't make any entries. No Input is possible. all buttons etc. are not usable, also the "next" or "back" buttom are not clickable. I can not proceed entering a formular to make analysis. It is only possible to exit this dialog using the esc button on the keybord.

also already existing diagrams or tables can no more be edited. same Problem.

did anyone experience the same issue? or has any advice fr me to solve it?

thanks.

How does one specify selection criteria when using the Beta Web Connector for SugarCRM in Qlik Sense Cloud?  Is there an additional parameter that must be added to the SELECT statement PROPERTIES?

SELECT

     id,

     name,

     date_entered,

     date_modified

FROM CustomModule

WITH PROPERTIES (

     moduleName='MyCustomModule'

     ,max_num='10000'

     ,order_by='date_modified:DESC'

);

Hi all,

When viewing embedded Qlik sheets on an internal web site, users are reporting that they receive intermittently "400 - Bad Request" errors or receive an error that the Qlik Sense engine wasn't found".

We found the below article and changed the proxy config accordingly ( https://support.qlik.com/articles/000098524).
Since we are running Qlik Sense for Windows June 2020 version, we thought this bug should not appear.
Anyway, changing the proxy config, did not help getting this resolved.

Do you have some hints, where to look at to resolve this problem?

Thanks,
Udo

js console error

Error message in browser

Hello,

Just wondering if anyone had successfully placed their NPrinting repository on a dedicated RDS server.

It seems like it would be easy enough to take what we have in the local NP repository and place it into another dedicated PostgreSQL database via PGAdmin Tool. However I am curious in terms of how to get the NPrintingRepo Service to know to connect to the external repository server.

There are other threads on altering pg_hba.conf or PostgreSQL.conf files (https://community.qlik.com/t5/Qlik-NPrinting-Discussions/How-to-connect-to-postgresql-database-from-another-server/td-p/1690365) but I believe these are based on local installations.

Please let me know if anyone has any experience on how to accomplish this.

Hello,

I have a Bar chart where I want to show the dimensions only if it has two conditions (field MakeBuy should be 'make' and the calculated value should be ave 0.2

=if((MakeBuy='make'and Sum({<Source={'AccountStructureSOW'}>} Value)/
Sum({<Unit={'Costs'}>}Value)>'0.2'),SubCompetency)

the formular is shown as OK but the dimension is not guilty. what did i wrong?

Best regards

Pia

Bonjour, 

Je fais des manipulations sur des dates, j'ai besoin de faire la différence entre deux dates en fonction d'un autre champ.
 

J'aimerai bien savoir, s'il y a une possibilité de faire la différence entre ( La date de fin [11/07/2020]  ) et ( la date de début [04/09/2020] ). Parce qu'en vrai, j'ai besoin de savoir est ce que la personne en question a repris le travail entre temps ou pas. Surtout, pour voir si elle a prolongé son arrêt ou elle a repris et ensuite elle a déposé un autre arrêt maladie.

En grosso-modo, je veux dire: Si ( [la date de fin (N-1)] - [la date de début (N)] ) > 1 donc le résultat sera de 1 sinon c'est 0 cela en fonction du nom de la personne .

Je vous remercie d'avance. 

QlikView 

When I try to create a connection to Azure Blob I have an error.

I select CanAutentificate.

After it, I got an authentification token and click Save Inputs & Run Table

in results I have an error