Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Boa tarde, Estou tentando fazer uma comparação entre o período atual - período passado / período passado * 100, o objetivo é conseguir uma variação de vendas em %, por exemplo, em meu filtro estou comparando o mesmo período em anos diferentes Fevereiro de 2023 e Fevereiro de 2024
A EXPRESSÃO QUE ESTOU USANDO É:
( ( Sum({<Ano_DC={"$(VAnoAtual_DC)"}, Mes_DC={"$(VMesAtual_DC)"}>} TOTAL_ITEM_DC) - Sum({<Ano_DC={" $(VAnoAnterior)"}, Mes_DC={"$(VMesAtual_DC)"}>} TOTAL_ITEM_DC) ) ) / Soma({<Ano_DC= {"$(VAnoAtual_DC)"}, Mes_DC={"$(VMesAtual_DC)"}> } TOTAL_ITEM_DC)
ENVIANDO AS VARIAVEIS
VAnoAtual_DC:
=MAX(Ano_DC)
VAnoAnterior:
=MAX(Ano_DC) -1
VMesAtual_DC:
=MAX(Mes_DC)
Hello,
Is there any way to chose the ledger format for a large report that I want to print directly from Qlik Sense? I want to avoid the action of loading the data in Excel. I noticed that when I want to have a PDF version, the document is like a photo, which mean, I cannot select the data...Is it because my administrator restricted me or Qlik Sense doesn't save any reports in PDF(not the printing version).
Thank you!
I can not get my QlikView desktop (edition info below) to lease a license from the server. When trying to connect to the server I get this pop up error. What am I doing wrong?
========================= QlikView Info ==========================
Client Version
Server Version
QlikTech Product QlikView 64-bit Edition (x64)
License Key [Personal Edition]
Production Date 2024-01-01
QV_BUILD_INFO release/QV12-80/55
PE Recoveries Remaining 1
CPU Target x64
======================= Local System Info ========================
Operating System Microsoft Windows 10 Pro (64 bit edition)
Operating System Version 10.0.19045
Wow64 mode Not using Wow64
IE Version 11.3636.19041.0
MDAC Version 6.3.9600.16384
MDAC Full Install Version 6.3.9600.16384
ComCtl32 version 6.16.10586
Current Theme C:\windows\resources\themes\Aero\Aero.msstyles
Graphics 1 1920*1080 pixels. 2 Monitors.
Graphics 2 32 Bit Color Depth. 96 XDpi. 96 YDpi.
Local Time 2024-05-09 15:46
GMT Time 2024-05-09 20:46
Country USA United States United States
Language 0409 English English
Physical RAM(MB) 16016
VMCommitted(MB) 88
VMAllocated(MB) 4983
VMFree(MB) 6378
VMLargestFreeBlock(MB) 6378
RecommendedFree(MB) 0
Number of CPUs 12
CPU 0 13th Gen Intel(R) Core(TM) i5-1345U 2496MHz
CPU 1 13th Gen Intel(R) Core(TM) i5-1345U 2496MHz
CPU 2 13th Gen Intel(R) Core(TM) i5-1345U 2496MHz
CPU 3 13th Gen Intel(R) Core(TM) i5-1345U 2496MHz
CPU 4 13th Gen Intel(R) Core(TM) i5-1345U 2496MHz
CPU 5 13th Gen Intel(R) Core(TM) i5-1345U 2496MHz
CPU 6 13th Gen Intel(R) Core(TM) i5-1345U 2496MHz
CPU 7 13th Gen Intel(R) Core(TM) i5-1345U 2496MHz
CPU 8 13th Gen Intel(R) Core(TM) i5-1345U 2496MHz
CPU 9 13th Gen Intel(R) Core(TM) i5-1345U 2496MHz
CPU 10 13th Gen Intel(R) Core(TM) i5-1345U 2496MHz
CPU 11 13th Gen Intel(R) Core(TM) i5-1345U 2496MHz
Hello,
I'd like to know if there is any way for a user that doesn't know anything about Qlik Sense to show drastically the filters that they are in. To make a story short, I'm currently building an interactive report with buttons, so the user can clik on them, but I want to make it obvious for them to know in what filters they are in. I know that we have the filters all the way up of the page, but sometimes, it's not that obvious.
I don't know if I'm expressing myself clearly, for an exemple, on Amazon site we can see this tree :
The filters doesn't have to be like that, its just an example, but something of this kind...
Thank you!
Hi,
I have migrated a .nsq file from NP-v16 to the Qlik Nprinting 2021 and changes to reports.
Now i want to import only one specific Report from .nsq zip file to overwrite the recent changes.
When i clicked on Import NP 16 Report(as in below screenshot), it shows all the other report except the report I want to replace.
Any suggestions, please.
Hi All,
In my project using Qlik Data integration here as Source; Sql server, Target: snowflake
After full load of the DB. Iam getting the below errror. Kindly share your suggestions as soon as possible.
Hi,
This is my first partipation in the Forum. I need some help with my app.
I have a master measure to count dengue cases from December 2022 to April 2023. The problem is that to filter the months I use a variable that contains the aggregation with an analysis set that filters the months, and I call it as a function with the year as a parameter (to be able to apply it to 2023/24) but with this I end up taking the months of the year that passed as a parameter, that is, if it is 2023 it takes: January, February, March, April and December, instead of taking : December (2022), January, February, March and April, that is, December is also 2023.
I tried to solve it by making a condition in my master measure so that when the month is December, I pass the previous year and the month of December as parameters, and if the month is any of the remaining months, I pass the current year and those months. I think it can work but when I spend several months as the 2nd parameter, it cuts off at the first comma it finds.
I give you a bit of the code of how I have proposed it. Notice for the abbreviations and names of variables, measures and dimensions are in Spanish
My master measure
if(Mes='Dic',${vCantCasos(2022,'Dic')},${vCantCasos(2023,${vSetMesesSinDi})})
The error
Hello,
I'd like to add a blank dimension, which mean nothing has to show in that column. What will be the expression for this, or is there any way that I can do this?
The purpose of this is to facilitate the copy of the data in an Excel sheet that has an extra column compare to the original extract in Qlik.
Thanks everyone!
Hi, we are in the process of porting a Qlikview app to Qliksense cloud, though we are running into a problem right now. On our qlikview app, we have a document trigger/action which automatically selects possible value(s) for some certain fields, with a few of them being hidden fields(leading underscore fields such as _UserTypeID and _GranteeID). We are unable to emulate this behavior on Qliksense, as the sheet actions will only allow us to choose non-hidden fields. Is this a limitation from Qliksense that we cannot bypass? And if so, what are the workarounds that we can use? Thanks.
We are trying to do CDC process in qlik with ODBC connection and backend is ProgressDB.
For CDC we found in source connections, under Change processing we have Context Column settings and Expressions to identify Update and Delete Operations.
What is the definition of context column, what if we have all the column at source apart from primary key any non-primary key changes how will qlik identify the changes. Is it possible or do we have to ive update expression.
and if we have to provide update expression please let provide us an example how the update expression.
Thanks,
snigdha
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!