Join a Group that is right for you and get more out of your collaborations. Some groups are closed. Closed Groups require approval to view and participate.

Explore

About Qlik Community

Get started on Qlik Community, find How-To documents, and join general non-product related discussions.

Explore

Blogs

Hear directly from Qlik employees in our ten unique blogs.

Explore

Qlik Resources

Direct links to other resources within the Qlik ecosystem. We suggest you bookmark this page.

Explore

Qlik Academic Program

Qlik gives qualified university students, educators, and researchers free Qlik software and resources to prepare students for the data-driven workplace.

Explore

Community Sitemap

Here you will find a list of all the Qlik Community forums.

Explore

Recent Discussions

Sort By:

New to Qlik Sense

Ip detail

Hi while running below command why I am getting different ip, what are all those Ips

By Mahamed_Qlik 2023-04-01 / 11:08 PM

0 0 6

New to Qlik Sense

Column transformation removal of extra numbers

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 ... Show More

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-1046.V2

ABC-1178.V2

ABC-1229.V2

ABC-1250.V2

ABC-1323.V2

ABC-1365.V2

ABC-1597.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

Show Less

111

Qlik Replicate

Failed to connect. SYS,GENERAL_EXCEPTION,Failed to connect,RetCode: SQL_ERROR Sq...

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... Show More

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.
Show Less

By ramu123 2023-04-01 / 10:55 AM

2 0 49
New to Qlik Sense

Calendar setting (default setting for xxx months)

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 dat... Show More

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
Show Less

By louise119 2023-04-01 / 05:15 PM

0 0 28
New to Qlik Sense

filter and output result table

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 d... Show More

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.
Show Less

By louise119 2023-04-01 / 05:09 PM

0 3 37
QlikView App Dev

Qlikview: Add an existing PDF-file to a report (and print the combination to PDF...

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... Show More

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
Show Less

By MrBosch 2023-03-26 / 07:33 AM

2 0 72
QlikView App Dev

Sort value on top, then descending on another dimension

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 3... Show More

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 ‌‌‌‌‌‌🙏
Show Less

By AleksandrShergin 2023-03-31 / 01:31 PM

1 0 53
Qlik Replicate

Error: Failed to connect to SQL Server EndPoint. Failed to load 'SQL Server Nati...

Hola,Here in our European project we are receiving the following error when trying to create Endpoint connection using Microsoft SQL Server.SYS-E-HTTP... Show More
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'..
- SYS,GENERAL_EXCEPTION,Stream component initialization function has failed for component 'SQL Server', type 'SQL Server'.,Error Initializing endpoint. Failed to load 'SQL Server Native Client 11.0' Cannot load <sqlncli11.dll, >: The operation completed successfully. Cannot load <sqlncli11.dll>: The specified module could not be found.
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?
Show Less
By mwallman 2020-08-13 / 09:41 AM

22 0 7293
New to Qlik Sense

A measure evaluting/counting another measure

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 ... Show More

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
Show Less

By Thomas_Qlik 2023-03-16 / 01:41 PM

2 0 68
App Development

QDF And structure of subs

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 scrip... Show More

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?

Qlik Sense Enterprise on Windows
Show Less

By mattiasthalen_enfo 2023-03-31 / 11:38 PM

1 0 40