Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
We have data in this format:
KPI | Market | Business | Month | Value |
A | 1/ | 11/ | January | 0.1 |
A | 1/ | 11/ | March | 0.2 |
A | 1/ | 11/ | June | 0.3 |
A | 1/ | 11/ | October | 0.4 |
A | 1/ | 11/ | November | 0.5 |
and I'd like to generate a table like this
KPI | Market | Business | Month | Value |
A | 1/ | 11/ | January | 0.1 |
A | 1/ | 11/ | February | |
A | 1/ | 11/ | March | 0.2 |
A | 1/ | 11/ | April | |
A | 1/ | 11/ | May | |
A | 1/ | 11/ | June | 0.3 |
A | 1/ | 11/ | July | |
A | 1/ | 11/ | August | |
A | 1/ | 11/ | September | |
A | 1/ | 11/ | October | 0.4 |
A | 1/ | 11/ | November | 0.5 |
A | 1/ | 11/ | December |
I'd like to avoid any loops if possible, since we have many KPI's, Markets and Businesses.
Hello Experts,
I want to do an analysis on Normal Distribution for Revenue. But not sure how to proceed with it as my requirement is to develop Bell Curve for Revenue as a measure. I am not sure how to proceed with it. Can anyone help me on this as anyone did any analysis on Bell curve for revenue.
I am using web version so please do not send the qvf files as will not be able to open them.
Thanks in advance
Ferha
Hi
A user can export and import existing application in QMC but cannot from Qlik Community.
Also unblocked the file after download.
As I am Admin I can do it. So what could be possible issue?
Hello,
I want to view my dashboard. But after I logged in it says "No Tenants to manage". I don't want to use qilk sense, But I just want to access my old dashboard. Please help me out with it.
Hi Everyone,
I have a folder with 3 years of data (monthly exports .csv files) there are total 36 files in the folder and names of files are Sales_Jan2023, Sales_Feb2023,Sales_Mar2023.
I am trying to load only the latest 6 months of data out of 36 files, How Can I do that, please help.
Hello Qlik Experts,
I am trying to create a pivot table in Qlik that shows "Current Sales" and "Previous Month Sales" for each "month year" selected.
However, I'm encountering issues with the accuracy of the figures for the previous month's sales, and I also need the pivot table to dynamically update based on multiple "month year" selections.
Data Structure:
Here is how my data is structured:
SalesDate | Product | Amount |
10/1/2023 | Chair | 50 |
15/1/2023 | Fan | 100 |
24/2/2023 | Chair | 82 |
23/2/2023 | Fan | 72 |
14/3/2023 | Chair | 132 |
13/3/2023 | Fan | 56 |
10/1/2024 | Chair | 50 |
15/1/2024 | Fan | 100 |
24/2/2024 | Chair | 82 |
23/2/2024 | Fan | 72 |
14/3/2024 | Chair | 132 |
13/3/2024 | Fan | 56 |
Measure for Sum of Amount for Selected Month
sum({<MonthYear,Month,Year,SalesDate = {">=$(=MonthStart(Max(SalesDate)))<=$(=MonthEnd(Max(SalesDate)))"}>} Amount)
Measure for Sum of Amount for Selected Previous Month
sum({<MonthYear,Month,Year,SalesDate = {">=$(=MonthStart(AddMonths(Max(SalesDate), -1)))<=$(=MonthEnd(AddMonths(Max(SalesDate), -1)))"}>} Amount)
Attached is the QVF.
Thank you very much for your assistance!
Hi Support,
We have recently seen an issue where the Qlik Enterprise Manager service fails to start with the QEM logs indicating the following error:
"[ERROR] REPO-E-FACSQLREP, Failed to connect to SQLite repository 'C:\Program Files\Attunity\Enterprise Manager\data\rtdata.sqlite' "
We were able to resolve the issue by stopping the QEM service and renaming the rtdata.sqlite file to rtdata_old.sqlite, and then renaming the rtdata.new.sqlite file to rtdata.sqlite. After then running the command to upgrade the repository (aemctl.exe repository upgrade), the QEM service was able to run and the console could be accessed.
Previously when we have seen an issue with a data repository file it has been a result of memory or disk space issues on the server. However, in this case, there have been no reported memory/disk space issues on the server. What we'd like to understand is what are the possible reasons the rtdata.sqlite file becomes unreadable/corrupted.
This instance of Enterprise Manager is v2023.11.0.259
Thanks,
Nak
Hi ,
I need to parse and load DB a pipe delimited file having data in the below structure using Talend.
Col1|Col2|Col3
"abc|111"|100|"zzz"
"xyz|222"|200|"yyy"
I am using dynamic schema as there are are multiple files with different schemas.(but all files follow the above rules).
Issue : It is note able to parse the entire content inside double quotes (abc|111) as single field.
Please help.
Thanks
Hi Team ,
We are replicating data from SQL Server to Postgresql
For SQL Server we are using MS-CDC for real time replication. But its Capture job is getting failed with error
nested limit exceed 32.
Version for SQL server is 2017 standard edition.
Any solution or ideas is appreciated !!!
I have the following where I'm parsing raw files into a dbTable then I want to iterate to a second sub with a tForeach
See attached example screenshot
When I try to connect the tForeach2 to the Raw transactions I get an error
Thanks for any help
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!