Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I use Windows 11, 64-bit 23H2, with 16 GB of RAM. I was using Qlik Sense Desktop November 2033 Patch 2 and everything was working fine. Today, I upgraded my version of Qlik Sense Desktop to the February 2024 Patch, and Qlik opens normally without any error codes or alert messages.
However, when I maximize Qlik to my full HD resolution, the Qlik window fills the screen, but the hub where the applications are located doesn't fill the screen. It appears as a square aligned to the left. I will attach a screenshot for reference.
Have you seen this issue before?
Note: I have hidden the names of the applications and the company logo in the screenshot.
Hi Team,
Attached are the visualization that i need and currently i am getting
My QR & QEM sit on 2XAWS EC2 instances, Windows OS. Timezone EST/EDT.
Analytics Repository is AWS Aurora (Postrgres).According to AWS the default is UTC.
My Analytics data (retrieval_time) is showing as matching Eastern Time values.
What I'm concerned about is (a) I need all my analytic data to be stamped by UTC and (b) conversions become complicated with DST.
What is the best way to get my analytics data by UTC time?
I have thought of altering the TZ at the windows OS level, but concerns this could affect other dependencies like maintenance & patching processes.
Any "best practices" anyone could share?
Thanks.
Hi
I trying to write script of an incremental load using 2 fields (VehicleID , RowID).
I would appreciate your help in writing the code for the process of incremental loading.
I want to take each time the new Data (Increment), which does not appear in the existing table, and add it to the existing data (Initial Data) and update if data was changed.
Thanks.
Initial Data:
VehicleID | RowID |
12345 | 1 |
12345 | 2 |
12345 | 3 |
21212 | 1 |
Increment:
VehicleID | RowID |
12345 | 4 |
21212 | 2 |
34343 | 1 |
Hi, i need to convert Datetime to Integer in Talend
- First i convert datetime to string
TalendDate.formatDate("yyyy-MM-dd HH:mm:ss:SSSS",row4.TimeStamp)
- Second i convert string to integer
StringHandling.LEFT(Var.var1,4) ==> as var2 (for getting date in expression)
Integer.valueOf(Var.var3) ==> (in output table)
but get wrong like below
There is no null data from the original table.
Then I added the following command and the data was successfully streamed but something went wrong in the YEAR column
Var.var2!=null?Integer.parseInt(Var.var2):null
the result
The year column contains a NULL value and the data contents in the YEAR column are not aligned with the rows so they do not match the TimeStamp column.
Can you help to resolve this problem?
I wrote the below Macro code using VBScript I know the code is correct. Anytime I press the button attached to macro on my system instead of the script to fire it was reopening the macro editor. please, what can I do apart from changing module security to system access in which I did but it is not running.
Sub HideTabRow
Set DocProp = ActiveDocument.GetProperties
DocProp.ShowTabRow=False
ActiveDocument.SetProperties DocuProp
End Sub
Sub ShowTabRow
Set DocProp = ActiveDocument.GetProperties
DocProp.ShowTabRow=True
ActiveDocument.SetProperties DocuProp
End Sub
This is the tableau sheet denoting sales and profit of a country in a map how can i achieve it in qlikview.Size of bubble depending on sales.and color gradient depend on profit.
I have 2 sheets that I am trying to use to obtain the scores of that particular device but the data is not unified automatically because the values differ slightly. How do I go about creating a formula that will match the "buzz values" to the cell I am trying to pull data from? Below is an example of what I am dealing with: I want the data value on the right to automatically associate the score from the data on the left by matching key words/value.
Hi everyone,
I wanted to apply the below filter on replicate but dont know whats the correct syntax for that , can someone help me on this
select * from CMS_BDR_AGG_GROUP where keysum not in (select distinct '%X'||agg_id||'X%' as keysum from CMS_REF_AGG where (agg_type=3 and NAME='HBCA') OR (agg_type=2 and NAME like '%HBCA%')) ;
I have been following the Top N the example on YouTube, but I guess I lost.
While the example only looks at Brand and Sales
In my example. I group Function, Name on Sales
When I do the of
Rank(Sum(Sales), Function, Name)<=10
It tested for -1 and 0. -1 means the Sales falls within the Top 10
However, when I try to bring the actual result so I can use variable input, it does not work.
This is what I am using to try to filter the column for only the Top 10
Sum(
{<
Function, Name={“= Rank(Sum(Sales), Function, Name)<=10
”}
>}
Sales)
Elevate your career with Connect. 15 Hands-on workshops and certifications for Data and Analytics.
Get to know these Qlik experts driving innovation and excellence in data, analytics and AI.
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!