Forums for Qlik Data Analytics solutions. Ask questions, join discussions, find solutions, and access documentation and resources.
Forums for Qlik Data Integration solutions. Ask questions, join discussions, find solutions, and access documentation and resources
Share your best Qlik apps and discuss impacts with peers! Show your work and get recognized for innovative uses of Qlik technologies.
Direct links to other resources within the Qlik ecosystem. We suggest you bookmark this page.
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'
);
Qlik Sense Integration, Extensions, & APIs
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.
Hi Experts,
I have 5 reports.
4-Excel and 1- Email embedded.
I need to send
first set- Straightforward without any task level filters -Achieved
Second Set -
4 Excel reports with a filter.(Column product having 6 values)
1 Email imbedded without any filter.(For all Products)
So i need to generate 4-excel+1 email embed(without any filter) for 6 product values.
Possible Solution is :
Create number of reports for each product value-in this case 4*6=24 reports which is not efficient i guess.
Can you please suggest me is there any other way to achieve without having to create so many reports
or is there anyway to exclude task filter for a report?
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.
Qlik Sense Integration, Extensions, & APIs
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
MVP
22788MVP
8646Employee
8635MVP
8190MVP & Luminary
7987Employee
6506MVP & Luminary
5329MVP
5172MVP & Luminary
4326Employee
4106Hear from the Qlik Community team about the latest platform enhancements and other topics.
Important and useful support information about end-of-product support, new service releases, and general support topics.
Hear directly from Qlik employees and stay current on the latest and greatest information about Qlik products.
We are bringing together people and resources in response to the pandemic of Coronavirus, aka COVID-19, aka SARS-CoV-2.
Join the QlikView to Qlik Sense group and help you modernize your BI experience through adoption of Qlik Sense.
This group is for healthcare organizations, partners, and Qlik healthcare staff to collaborate and share insights.
Virtual Meetups are now a possibility! With the impact of COVID-19, the Qlik Meetup network has expanded its support to include the ability to host your next Meetup online. Email QlikMeetups@qlik.com to get your virtual Meetup started!’
Qlik can help you manage your supply chain risks during COVID‑19.The nonprofit organization, Direct Relief, uses Qlik’s Supply Chain solution to scale its delivery of medical supplies worldwide.