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 all,
I have an automation based on Solved: Re: Qlik Automation, Generate excel file based on ... - Qlik Community - 1944201 using the Scheduled Report (Dimension Cycle) JSON template.
The automation works perfectly, by looping and adding all of the data from the Qlik report into an excel spreadsheet and saves to OneDrive just fine.
I get an error saying that the drive_id and item_id are required for the excel block but these are mapped to the file created earlier in the automation.
I have attached the JSON and some screenshots if anyone is kindly able to assist.
Thanks,
Lewis
Qlik Compose for Data Warehouses
Hello everyone,
in qlik sense
I have a timestamp in a string format and I need to convert it into a date and time with e specific format.
the idea is to be able to create a calendar or extracts month.week...etc from that field, which is not possible when it's a string
We have created a ticket with this question, and they suggested asking this question in the Community.
We would like to send a notification (email) when we get bad data.
Source target Oracle, data type character.
Endpoint target Confluent v7 Kafka Avro primitive.
Background.
We have an older app running that uses Oracle that has date columns defined as char(8). This means users can (and do) enter invalid dates. We transform the character to datetime, and can test using Sqlite for a valid date, but cannot send an email from Sqlite, or from Replicate. When the invalid date is sent to Kafka it shows up as 9999-12-31 23:59 so it's no longer valid. We haven't found an easy way in our data stream to capture the date. We have looked at the user defined function in the expression builder, but currently do not have a C programmer on in our group.
Question
Is there a way to send a notification (email) from Qlik on bad data?
Hi,
I have many cases in my data where the question asked essentially is:
if value () doesnt appear // does appear in this table then 'Yes' else 'No'
this simple formula is proving very challenging to do without creating synthetic keys.
Is there an easy one line formula you are able to slot into the actual table in the load editor that would solve this. For example:
Load
*,
If......'yes','no
from File
Please help
Hi,
I'd need to calculate a cumulative sum in the line chart, but this formula doesn't work:
=RangeSum(Above(TOTAL Sum({$<[Type]={'$(vType)'},[Product Line]={'Product 1'},[Account channel]={'Direct'}>} [Value]),1,RowNo(TOTAL)))
I'll have 1 line for actual and 1 line for target in the same line graph and I'd like to cut the actual line - please see the example chart below:
Any idea how to solve this? Thanks!
Hi every one ,
i developped a qlikview file .qvw in the server and i want to share to be visible for users , it how i can do it ,
Thanks
Hi Community,
I have given below data set:
Date | Periods | Franchise | Country | Orders_Numbers |
01.01.2022 | 1 | Burger | USA | 101 |
01.01.2022 | 2 | Burger | Canada | 101 |
01.01.2022 | 3 | Burger | Australia | 101 |
01.01.2022 | 4 | Burger | France | 102 |
01.01.2022 | 5 | Burger | Spain | 102 |
01.01.2022 | 6 | Burger | Italy | 102 |
If I write Expression in the GUI: Count(DISTINCT Orders_Numbers) then I'll get 1 for the Orders_Numbers = 101 whenver I'll select / deselect any dimension on the GUI. If I'll clear all the dimensions then I'll get 2. One for each Orders_Numbers due to Count(DISTINCT Order_Numbers).
I want to achieve the same results using Edit Script. How to do it ? I don't want to remove any dimension Filter from the GUI.
I tried this solutions to achieve the same results but the problem is I got 3 for the Orders_Numbers = 101. Becaue the %Key has a unique Periods in the %Key that makes it unique while I count on the GUI then it returns me the 3 not one due to the %Key. If I write DISTINCT in the Expression then I'll always get 1 for all the data set.
Do I need to change the expression after the below load edit script or what is the right way to do it ?
We have a client considering a move to saas, so I downloaded the qlik sense migration app. Unfortunatly you need a cloud tenant to to the check. Older versions are without this connection to cloud.
Does anyone have an older version of the cloud Readiness app? One without the connection to cloud?
Kind regards,
Isabelle
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
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!