Everything you need to make your Qlik Community experience valuable.
Explore official Support and member created content.
Welcome Emmy award-winning Katie Linendoll as our emcee and world record-holding cave diver John Volanthen as our keynote speakers.
Forums for Qlik Data Integration solutions. Ask questions, join discussions, find solutions, and access documentation and resources
Share your best Qlik apps and discuss impacts with peers! Show your work and get recognized for innovative uses of Qlik technologies.
Get started on Qlik Community, find How-To documents, and join general non-product related discussions.
Direct links to other resources within the Qlik ecosystem. We suggest you bookmark this page.
Qlik gives qualified university students, educators, and researchers free Qlik software and resources to prepare students for the data-driven workplace.
Hi
I have sample data as show below
Parent |
ABC-1013.V2-24187 |
ABC-1013.V2 |
ABC-1046.V2-24428 |
ABC-1046.V2 |
ABC-1178.V2-25465 |
ABC-1178.V2 |
ABC-1229.V2-25925 |
ABC-1229.V2 |
ABC-1250.V2-26366 |
ABC-1250.V2 |
ABC-1323.V2-27096 |
ABC-1323.V2 |
ABC-1365.V2-24243 |
ABC-1365.V2 |
ABC-1597.V2-19167 |
ABC-1597.V2 |
ABC-1631.V2-25265 |
ABC-1631.V2 |
ABC-1701.V2-21053 |
Output should for above table:
parent |
ABC-1013.V2 |
ABC-1013.V2 |
ABC-1046.V2 |
ABC-1046.V2 |
ABC-1178.V2 |
ABC-1178.V2 |
ABC-1229.V2 |
ABC-1229.V2 |
ABC-1250.V2 |
ABC-1250.V2 |
ABC-1323.V2 |
ABC-1323.V2 |
ABC-1365.V2 |
ABC-1365.V2 |
ABC-1597.V2 |
ABC-1597.V2 |
ABC-1631.V2 |
ABC-1631.V2 |
and I have 2nd Requirement:
Table 2:
Column A, "Requirement is the data set", I want to get the Column B "Expected Output"
These two requirements, Can anyone please help me on this
Requirement | Expected Output |
ABC-1046.V2 (3) | ABC-1046.V2 |
ABC-1178.V2 (3) | ABC-1178.V2 |
ABC-1229.V2 (3) | ABC-1229.V2 |
ABC-1597.V2 (3) | ABC-1597.V2 |
ABC-1701.V2 (32) | ABC-1701.V2 |
ABC-5018.V1 (3) | ABC-5018.V1 |
ABC-5025.V1 (3) | ABC-5025.V1 |
ABC-5056.V1 (3) | ABC-5056.V1 |
ABC-5058.V1 (4) | ABC-5058.V1 |
ABC-5059.V1 (3) | ABC-5059.V1 |
ABC-5064.V1 (3) | ABC-5064.V1 |
ABC-5065.V1 (3) | ABC-5065.V1 |
ABC-5082.V1 (1) | ABC-5082.V1 |
ABC-5119.V1 (1) | ABC-5119.V1 |
ABC-1631.V2 (3) | ABC-1631.V2 |
ABC-5067.V1 (4) | ABC-5067.V1 |
ABC-5091.V1 (4) | ABC-5091.V1 |
ABC-5106.V1 (4) | ABC-5106.V1 |
ABC-5107.V1 (1) | ABC-5107.V1 |
ABC-994.V3 (3) | ABC-994.V3 |
ABC-5060.V1 (3) | ABC-5060.V1 |
ABC-5086.V1 (6) | ABC-5086.V1 |
ABC-5087.V1 (6) | ABC-5087.V1 |
ABC-5093.V1 (2) | ABC-5093.V1 |
ABC-5094.V1 (1) | ABC-5094.V1 |
ABC-5095.V1 (3) | ABC-5095.V1 |
ABC-5098.V1 (1) | ABC-5098.V1 |
ABC-5100.V1 (1) | ABC-5100.V1 |
ABC-5113.V1 (1) | ABC-5113.V1 |
ABC-5114.V1 (1) | ABC-5114.V1 |
ABC-5115.V1 (1) | ABC-5115.V1 |
ABC-5116.V1 (1) | ABC-5116.V1 |
ABC-5117.V1 (1) | ABC-5117.V1 |
ABC-5118.V1 (1) | ABC-5118.V1 |
ABC-975.V2 (3) | ABC-975.V2 |
ABC-976.V2 (3) | ABC-976.V2 |
ABC-1013.V2 (3) | ABC-1013.V2 |
ABC-1250.V2 (3) | ABC-1250.V2 |
ABC-1323.V2 (3) | ABC-1323.V2 |
ABC-1365.V2 (3) | ABC-1365.V2 |
ABC-28.V2 (3) | ABC-28.V2 |
ABC-417.V2 (3) | ABC-417.V2 |
ABC-419.V2 (6) | ABC-419.V2 |
ABC-5004.V1 (1) | ABC-5004.V1 |
ABC-5061.V1 (3) | ABC-5061.V1 |
Hi all,
I'm using MS SQL SERVER is a source database and target database as well.(For Qlik replicate).
My Question is Here: Log stream is stopped and due to below this error and I'm unable to resume the log stream and end point connections also not succeeded.
Creating Metadata Manager's utility components failed
Cannot create the source utility component
Failed while preparing stream component (Source database)
Failed to connect
RetCode: SQL_ERROR SqlState: 08001 NativeError: 10061 Message: [Microsoft][ODBC Driver 17 for SQL Server]TCP Provider: No connection could be made because the target machine actively refused it.
Is it possible to set the initial value of the calendar to the same period (for example, 2 months) on all sheets?
I'm currently using items from a data table for my calendar.
The date values in each data (data table A.data, data table B.data, data table C.data) are different, but I would like to specify two months as an initial setting.
How can I set it so that when I open the app and open a sheet, I can specify the dates for the last two months no matter which sheet I open?
ex)
Sheet A:
Calendar → Data table A.data
Sheet B:
Calendar → Data table B.data
Sheet C:
Calendar → data table C.data
Hi. I want to ask about filter and output result table.
When I select data in the output result table, I want nothing to happen (the filter condition does not change).
I'm trying to narrow down the conditions with a filter and display the selected conditions in a table.
As you select some values in this output table, the filter criteria will change accordingly.
Is it possible to lock the result table so that nothing changes when clicked?
Thank you.
Hi All
In a dashboard I create a nice report but I want to combine this with an existing report.
The external two-pages pdf should become some kind of object that will be embedded into my style. Is this possible?
Even better would it be that I could define the exact two positions on a page so that the source can be cropped to those two points.
Anyone who had to deal with such a challenge?
Thanks,
Alex
Hi all!
I'm new here, I really need your help.🖐
I have a source table with 3 dimensions
Date1 | Product | Value |
31.01.2023 | D | 15 |
30.01.2023 | C | 0 |
31.01.2023 | C | 10 |
31.01.2023 | B | 0 |
28.01.2023 | B | 0 |
31.01.2023 | A | 0 |
29.01.2023 | B | 5 |
27.01.2023 | B | 10 |
30.01.2023 | A | 12 |
My goal is to sort it like this
Date1 | Product | Value |
31.01.2023 | A | 0 |
31.01.2023 | B | 0 |
30.01.2023 | B | 0 |
30.01.2023 | C | 0 |
29.01.2023 | A | 0 |
28.01.2023 | A | 0 |
31.01.2023 | B | 15 |
31.01.2023 | C | 10 |
30.01.2023 | D | 20 |
So that zeros are at the top, sorted by date in descending order and product alphabetically, all other values are also sorted by date in descending order and product alphabetically.
I know it can be done with a hidden column, but my goal is not to use an extra column.
When I sort by value expression I don't get what I want
Not all dates are descending
I want to get this result
I attach an example qvw
It seems like it should be very simple, but I can't find a solution.
I would appreciate any help 🙏
Hola,
Here in our European project we are receiving the following error when trying to create Endpoint connection using Microsoft SQL Server.
SYS-E-HTTPFAIL, Stream component initialization function has failed for component 'SQL Server', type 'SQL Server'..
We have ensured the SQL Server Native Client 11.0 is installed from here https://www.microsoft.com/en-sg/download/details.aspx?id=36434
We can see the sqlncli11.dll file in the C:\Windows\WinSxS\amd64... folder.
Anybody know how to solve this error please?
I have a key (e.g. AN) that consists out of several attributes (e.g. AN-WERT2, AN-XW2JA), which each have a value (e.g. 0, Yes).
What I would like to do is to compare for each attribute the AS IS values against certain predefined TO BE values. I have written a measure m_P2P09_Attribute_Compliant, which compares the two tables holding the AS IS and TO BE values with each other.
As a second step –and here I get stuck- I want to assess for each key whether it is compliant. Meaning: All the attributes of this key are compliant (Measure m_P2P09_Attribute_Compliant=”Yes”). If a key has one or more attributes with “No” it would not be compliant.
I thought I could do this assessment with another Measure: m_P2P09_Key_Compliant, which would deliver back “Yes” or “No”.
Can anybody please help me out how the logic of the Measure m_P2P09_Key_Compliant measure would look like?
Much appreciated,
Thomas
I’m curious, how do you store your subs?
I’m torn between storing them all in one script, storing them collected into “library scripts”, or one script per sub.
The QDF subs are stored with each sub in a separate script.
What do you prefer, and why?
Hear from your Community team as they tell you about updates to the Qlik Community Platform and more!
If you want to know what's new across all of the products in our growing Qlik product portfolio.
Get the latest Support information about end-of-product support, new service releases, and general support topics.
Read all about Qlik solutions: scripting, data modeling, visual design, extensions, best practices and more.
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.
10+ hours of roll up your sleeves, immersive working sessions. A $1000 value included in your conference pass!
Subscribe to our Events and Webinar page so you do not miss an event
opportunity!
Join the "Welcome to Qlik" webinar and learn about the Qlik Ecosystem, such as Qlik Community, Learning, and Help.
There is more than one way to find upcoming events, look on the right side
of any Qlik Community forum!
Subscribe to our Events and Webinar page so you do not miss an event
opportunity!
Join the "Welcome to Qlik" webinar and learn about the Qlik Ecosystem, such as Qlik Community, Learning, and Help.
There is more than one way to find upcoming events, look on the right side
of any Qlik Community forum!