Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have a data set and I want those with invoice type T to be excluded from the calculation. Those with account number 191 are my vat number. Here, I want to show the ones other than those with account number 191 and invoıce type T and distribute them as a percentage to the vat number.
How can I do this on the script side?
Invoıce Number | Invoıce Type | Account Number | Price |
2023000006501 | G | 730 | 2.883.056,72 |
2023000006501 | G | 191 | 588.066,59 |
2023000006501 | G | 770 | 57.276,24 |
2023000006501 | T | 320 | 0,00 |
I want to result:
Invoıce Number | Account Number | Price | VAT | |
2023000006501 | 730 | 2.883.056,72 | %98.05 | 576.60 |
2023000006501 | 770 | 57.276,24 | %1.95 | 11.470,00 |
Hello Qlik Community,
In testing the latest version of Qlik NPrinting : February 2024 SR1 (does not appear yet in product labels) , I tumbled on an issue.
For the tasks (even for those which already send email) in the email configuration, the destinations emails don't retain.
After looking around, I've noticed the same issue with the Settings\Task options under Notifications.
I've noticed also this info bubble:
Which stays active even though the System URLs have been configured.
The Email settings are configured and work to send test email, even for the task which were already configured before the update (although they don't show their value in console).
Now changing the email causes no change in "Cancel" / "Update" buttons, they stay greyed out as if there was no modifications. And modifying other elements like the Body of an email, or ticking another option, often un-grey only the Cancel button but not the update.
I've also tried to restart the services in vain.
Does someone has a clue of what is happening ? It seems that the link between the task and email form the previous version still works, but somehow is not available anymore. Can someone help me find the missing link ?
Hi there,
I am trying to compute a 5-weeks moving average correctly to display it in a graph in a Nprinting report.
Basically my data looks like the attached example :
- week id
- Nb is my measure
- Moving average 5 weeks : the 5-week moving average of the measure "Nb"
I want to display "Nb" and its "Moving average 5 weeks" only over the last 10 weeks, so between week 202411 and 202420 in my example.
But for weeks 202411 to 202415, I need older data points to be able to compute properly the 5 weeks rolling average, example :
Moving average 5 weeks for week 202411 = (120 + 200 + 27 + 128 + 625 )/5 = 220
Problem : if I filter on the last 10 weeks only, I miss older data required to compute properly the 5-weeks rolling average. For 202411, I will only get 120/5 = 24 which is wrong.
How can I do to compute properly the moving average for each point and only then, filter to display only the 10-week period of my interest ?
What I have already tried without success :
- compute the moving average in QlikSense and then filter on 10 last weeks in Nprinting graph : FAILED
- filter on 20 last weeks in Nprinting graph to get correct moving average value and then apply an additional filter on 10 last weeks at task level (hoping the aggregation would be performed before the final filter on period) : FAILED
Thanks for your help
Hi ,
Could someone help me rectify the error in following script(Attached screenshot).
Getting error 'ValueCategoryGlobal' and 'ProcessTypeGlobal' not found. Though these fields are present in residents tables Valuecategory and ProcessType respectively.
I am expecting Fields Value, ValueCategoryGlobal and ProcessTypeGlobal in temp table. But only field coming is Value.
Preciso de uma solução para que os dados dos dashboards do qlik sejam atualizados em uma tabela do excel.
Quem puder me ajudar, agradeço.
I've been trying all day to create YTD perios in order to create a chart showing figures compared over the current year period. I'm used to having YTD's in my data and simply adding them to my chart in Excel but in Qlik, I can't seem to work this out.
Below is how I would have it created in Excel:
This makes an easy year on year comparison possible.
But how can I get ytd's and add them to a grouped bar chart like above AND have these refreshed automatically upon a new data load?
I' ve been puzzling with expressions for dimensions in the chart but that didn't work out, I tried to add a variable containing the YTD (add wanting to add YTD-1 and YTD-2 later on).
Hi All,
We are migrating the server from RHEL 7 to RHEL 8.
We have a PostgreSQL target.
From new box, RHEL 8, we are able to connect via command line to PostgreSQL but while trying to test connection from the Qlik UI, we are getting the below error:
Cannot connect to ODBC provider
RetCode: SQL_ERROR SqlState: 01000 NativeError: 0 Message: [unixODBC][Driver Manager]Can't open lib 'PostgreSQL' : file not found
Below is the o/p of site_arep_login.sh and /etc/odbcinst.ini. With same settings, it was connecting in RHEL 7.
[root@**]# cat site_arep_login.sh
# enter site specific settings here
#export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/u01/app/oracle/product/193000/client_1/lib/
export NLS_LANG='ENGLISH_UNITED KINGDOM.AL32UTF8'
export ORACLE_HOME=/u01/app/oracle/product/193000/client_1/
export TNS_ADMIN=/u01/app/oracle/product/193000/client_1/network/admin/tnsnames.ora
export LD_LIBRARY_PATH=/usr/lib:/usr/lib64:/usr/pgsql-14/lib:/opt/snowflake_odbc/lib:/u01/app/oracle/product/193000/client_1/lib/:$LD_LIBRARY_PATH
[root@**]# cat /etc/odbcinst.ini
# Driver from the postgresql-odbc package
# Setup from the unixODBC package
PostgreSQL]
Description = PostgreSQL ODBC driver
Driver = /usr/pgsql-14/lib/psqlodbc.so
Setup = /usr/pgsql-14/lib/psqlodbcw.so
Debug = 0
CommLog = 1
UsageCount = 2
[SnowflakeDSIIDriver]
APILevel=1
ConnectFunctions=YYY
Description=Snowflake DSII
Driver=/opt/snowflake_odbc/lib/libSnowflake.so
DriverODBCVer=03.52
SQLLevel=1
Hi experts,
I am new to Qlik and I need your help. I have two dates fields as shown below. I need to create intervals of 6months below, 2-5 years, etc, and sum my sales based on these intervals. Can anyone help me please? Thank you.
Start Date | End Date | Expected | expected sum of sales |
10/08/2010 | 04/02/2011 | Within 6 Months | 40 |
15/02/2011 | 22/03/2022 | Up to 2 years | 80 |
05/07/2010 | 10/07/2011 | 2-5 Years | 30 |
11/05/2009 | 15/07/2013 | Above 5 years | 90 |
10/03/2010 | 07/05/2012 | ||
12/09/2013 | 20/06/2017 |
Hi Qlikies,
Is there a way to read the Custom property data from the QRS, logs. I tried to look into the Operations monitor, but there is no trace of any dimension holding the Custom property data.
I would like to load the data of custom property and its associated users from the QRS or the operations monitor.
Thanks
Mark
Hi,
I have published an app und now I need some changes in the app. How can I reverse publishing an app?
Is this something to do in QMC?
I guess this is an easy one, but couldn't find it in the user guide.
Best regards
Hans-Peter
Wondering about Qlik Talend Data Integration Sessions? There are 11, in addition to all of the Data & Analytics. So meet us in Orlando, June 3 -5.
Join us on May 15th at 11 AM ET to discuss the Qlik Ideation Process. Bring your questions.
Browse our helpful how-to's to learn more about navigating Qlik Community and updating your profile.
Your journey awaits! Join us by Logging in and let the adventure begin.
Qlik enables a frictionless migration to AWS cloud by Empresas SB, a group of Chilean health and beauty retail companies employing 10,000 people with 600 points of sale.
Qlik Luminary Stephanie Robinson of JBS USA, the US arm of the global food company employing 70,000 in the US, and over 270,000 people worldwide.
Join one of our Location and Language groups. Find one that suits you today!
A private group is for healthcare organizations, partners, and Qlik healthcare staff to collaborate and share insights..
Qlik Communityの日本語のグループです。 Qlik製品に関する日本語資料のダウンロードや質問を日本語で投稿することができます。
Welcome to the group for Brazil users. .All discussions will be in Portuguese.
Hear from your Community team as they tell you about updates to the Qlik Community Platform and more!