Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Qlik,
I want to ask about the specifications of Qlik Replicate Enterprise Manager Repository.
We use AWS PostgreSQL RDS as a repository. What are the minimum specifications?
Thank you.
Best regards,
Herra
Hello Community,
i have a column in "sectors" and i also have "Tkt_no" column
so same "Tkt_no" I am getting multiple "sectosrs" see blow
current output
"Tkt_no" "sectors"
6697256429 JNBPOL
6697256429 POLJNB
6697256429 BOMDOH
6697256429 DOHJNB
Expected Output
"Tkt_no" "sectors"
6697256429 JNBPOL,POLJNB,BOMDOH,DOHJNB
I created 2 tables(qlik_users and qlik_attribute) in database (screenshot attached)
and successfully synced then using user directory connector ,
But these synced users are failing to authenticate / login to Qlik hub and QMC
Tried different ways to resolve this , -
But nothing worked, please help if anyone can provide suggestions
Hi,
I have data like this and when we do the calculation like below it ends up with duplicates.
if(num([cal date])-num(today())>0 and confirmed='N',1,0) as "Review Eve"
expression: sum("Review Eve") gives duplicates
ref | cal date | major code | minor code | review | quoted amt | agreed amt | confirmed | today() |
00ACCL27 | 01-04-2016 | 200 | 100 | Initial Rent | 177947.88 | Y | 09-05-2024 | |
00ACCL27 | 01-04-2016 | 200 | 130 | Initial Rent | 14351.93 | Y | 09-05-2024 | |
00ACCL27 | 01-01-2017 | 200 | 100 | Rent Review | 177948 | Y | 09-05-2024 | |
00ACCL27 | 01-01-2017 | 200 | 130 | Rent Review | 14352 | Y | 09-05-2024 | |
00ACCL27 | 01-04-2019 | 200 | 100 | Rent Review | 177947.88 | 177947.88 | Y | 09-05-2024 |
00ACCL27 | 01-04-2019 | 200 | 130 | Rent Review | 14351.93 | 14351.93 | Y | 09-05-2024 |
00ACCL27 | 01-04-2022 | 200 | 100 | Rent Review | 177947.88 | 177947.88 | Y | 09-05-2024 |
00ACCL27 | 01-04-2022 | 200 | 130 | Rent Review | 14351.93 | 14351.93 | Y | 09-05-2024 |
00ACCL27 | 01-04-2025 | 200 | 100 | Rent Review | 177947.88 | 0 | N | 09-05-2024 |
00ACCL27 | 01-04-2025 | 200 | 130 | Rent Review | 14351.93 | 0 | N | 09-05-2024 |
00ACCL27 | 01-04-2028 | 200 | 100 | Rent Review | 177947.88 | 0 | N | 09-05-2024 |
00ACCL27 | 01-04-2028 | 200 | 130 | Rent Review | 14351.93 | 0 | N |
09-05-2024
Dear colleagues
we use Qlik sense enterprise on windows 2023May currently.
If we want to upgrade to February 2024 what is correct steps and is there a manual I can follow.
whether we need backup before upgrade.
we also hope to be sure license also can be used after upgrade.
it is better can get your support ASAP.
😊
jens.
Hi, I would like to calculate rolling sum like in the table below. Data should be grouped by column "Family". For each quarter I want to take a look at current quarter and 2 quarters backwards. Any idea how to achieve this in script editor? I am not interested in set analysis using rangesum - above combination. Column "Quarter" comes from fiscal master calendar.
Thank you.
Family | Quarter | Qty | RollingSum3 | Family,Quarter,Qty |
A | FY2023Q2 | 10 | 10 | A,FY2023Q2,10 |
A | FY2023Q3 | 20 | 30 | A,FY2023Q3,20 |
A | FY2023Q4 | 30 | 60 | A,FY2023Q4,30 |
A | FY2024Q1 | 40 | 90 | A,FY2024Q1,40 |
A | FY2024Q2 | 50 | 120 | A,FY2024Q2,50 |
A | FY2024Q3 | 60 | 150 | A,FY2024Q3,60 |
A | FY2024Q4 | 70 | 180 | A,FY2024Q4,70 |
B | FY2023Q2 | 5 | 5 | B,FY2023Q2,5 |
B | FY2023Q3 | 10 | 15 | B,FY2023Q3,10 |
B | FY2023Q4 | 15 | 30 | B,FY2023Q4,15 |
B | FY2024Q1 | 20 | 45 | B,FY2024Q1,20 |
B | FY2024Q2 | 25 | 60 | B,FY2024Q2,25 |
B | FY2024Q3 | 30 | 75 | B,FY2024Q3,30 |
B | FY2024Q4 | 35 | 90 | B,FY2024Q4,35 |
Hi All,
I have text box in Qliksense and I have mentioned Required text in text box.
My system it is showing proper and some one having issues like if there are seeing dashboard in bigger screen then the font size will changes.
Can please suggest me how to handle when moving from smaller screen to bigger screen or bigger screen to smaller screen the font size won't change.
Thanks & Regards,
Lakshman
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
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!
let prevmon=date(addmonths(today(),-1),'MMM YYYY');
LOAD
"As of Date",
"xxxx",
"xxx",
"XXXX",
"XXXX"
FROM [lib://Source/SourceLanding/Reports/monthlyDetail report as of $(prevmon).xls]
(biff, embedded labels, table is [qry For Comments$]);
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!