Ask a Question

Welcome to
Qlik Community!

Recent Discussions

Sort By:

New to Qlik Analytics

Unable to upload file to App Contents

I was able to upload files to App Contents on my Qlik Sense Enterpise the day last week. But i was given error since monday, "Error uploading file". b... Show More

I was able to upload files to App Contents on my Qlik Sense Enterpise the day last week.

But i was given error since monday, "Error uploading file". been trying to resolve it but unable to do so.

i am able to delete files in the app content, but unable to update any files at all. Even files that i was able to do so previsouly.

Would appreciate if anyone can assist.
Show Less

By zdxpw 2024-04-04 / 01:34 AM

3 0 109
Deployment & Management

How can I global search a data connection used in an app

As we have many many apps, there is a server going to be decommissioned. I found the related data connection name. How I can search across all apps i... Show More

As we have many many apps, there is a server going to be decommissioned. I found the related data connection name.

How I can search across all apps if that Data Connection been used?

Thanks in advance.
Show Less

By HI6 2024-05-05 / 10:46 PM

0 0 1
Qlik Application Automation

Darshan Hiranandani - What is the process for setting up an integration between ...

Hey team, I'm Darshan Hiranandani, looking to set up an integration between App A and App B. Could anyone share their suggestions or experiences on... Show More

Hey team, I'm Darshan Hiranandani, looking to set up an integration between App A and App B. Could anyone share their suggestions or experiences on the process for setting up such integrations? Your insights would be really helpful!

Show Less

By darshanhiranandani 2024-05-05 / 10:36 PM

0 0 5
Installing and Upgrading

TAC 8.0 Warning: Can't access git server. Please check URL and authentication.

Hello Community User's,We configured TAC 8.0 & we are getting warning on TAC 8.0 Projects tab: Can't access git server. Please check URL and authentic... Show More

Hello Community User's,
We configured TAC 8.0 & we are getting warning on TAC 8.0 Projects tab: Can't access git server. Please check URL and authentication
TAC server is able to communicate to Git.
we can curl and ping to git from TAC server.
we can add new projects and connection check is giving ok .. however after few seconds it throws the same warning.
we are not using any ssl certificate for communication between TAC and Git.
Git clone is also working as expected.
Please advise if some else has faced the same issue with TAC8.0 and has some solution.
I would really appreciate !!!
Thanks
Amit
Show Less

By amit01123 2023-03-10 / 07:25 AM

9 1 295
New to Qlik Analytics

I Can only See My Qlik Profile page. Can't Access anything else

Hi Everyone,I have registered with Qlik on free trial basis, but i can only see my profile page, nothing else is accessible to me, how to get started ... Show More

Hi Everyone,

I have registered with Qlik on free trial basis, but i can only see my profile page, nothing else is accessible to me, how to get started with the free trial ? so i can play around with Qlik and know its features.

Thanks
Show Less

By kazmibilal1 2024-05-05 / 09:39 PM

0 0 22
Data Quality, Preparation & Stewardship

should not be able to select all the columns.

Hello. I have a table in table format, and you can add columns to it by selecting them. There are quite a few columns. There are three accounts that c... Show More

Hello. I have a table in table format, and you can add columns to it by selecting them. There are quite a few columns. There are three accounts that can access this table, and what I need is for only the selected account to be able to select all the columns. Other accounts should not be able to select all the columns.
Show Less

By vuqar 2024-05-04 / 11:15 PM

1 1 44
Qlik Replicate

Call an API from Replicate

Hello: We have a need to transform as we replicate using a 3rd party transformer that provides an API. Is there a way to invoke an API for each row as... Show More

Hello:

We have a need to transform as we replicate using a 3rd party transformer that provides an API. Is there a way to invoke an API for each row as it is being replicated?

Thanks,

Manas.
Show Less

By MDAtl 2024-04-26 / 08:21 AM

7 1 203
New to Qlik Analytics

Set analysis to get value based on month selection

I am trying to calculate the sum of the debits for the current month using the formula below. I'm not sure what I'm doing wrong here because I get onl... Show More

I am trying to calculate the sum of the debits for the current month using the formula below. I'm not sure what I'm doing wrong here because I get only 0s with this formula.

sum({$<GL_Month={"=$(=Date(Floor(MonthStart(Max(ActualsDate))),'MMM-YYYY'))"}>}Accounted_Debit)

I want to calculate the value for the previous month as well.

GL_Month is the month column that is derived in the script with the following formula :

Date(MonthStart("ActualsDate"), 'MMM-YYYY') as GL_Month,

Show Less

By QS_ 2024-05-05 / 01:04 AM

4 2 114
App Development

Bar chart changes color based on the measurement

The dimensions of the bar chart are Site, Measure 1 is Days1, Measure 2 is Days2, Measure 3 is Days4. I want Days1 to be displayed in white, Days2 in ... Show More

The dimensions of the bar chart are Site, Measure 1 is Days1, Measure 2 is Days2, Measure 3 is Days4. I want Days1 to be displayed in white, Days2 in green, and Days3 in red. How do I write the color expression?

Show Less

By mingyu 2024-05-05 / 06:52 PM

0 1 37

Incorrect KPI calculation

Hi, I have a problem in the data model and KPIs.The Facts table consists of several tables (concatenate), and there is a dimension table that contains... Show More

Hi,

I have a problem in the data model and KPIs.
The Facts table consists of several tables (concatenate), and there is a dimension table that contains flags.
I want to count the amount of values in a packet according to a certain flag and I don't get data.

How can I solve this?

Simple example

Fact:

SourceTable	num(Date)	StoreID	OrderID	ItemID	Qty	Amount	GoalAmount	Key
Orders	44444	001	1001	a001	1	100	-	44444 \| 001
Orders	44444	001	1001	b002	1	150	-	44444 \| 001
Orders	44444	001	1002	a001	2	200	-	44444 \| 001
Orders	44444	002	2001	c003	5	50	-	44444 \| 002
Orders	44444	002	2002	a001	4	350	-	44444 \| 002
Orders	44444	001	1003	b002	2	300	-	44444 \| 001
Goals	44444	001	-	-	-	-	700	44444 \| 001
Goals	44444	002	-	-	-	-	800	44444 \| 002

Dim:

Key	flag1	flag2	flag3
44444 \| 001	1	1	0
44444 \| 002	0	1	1
44444 \| 003	1	1	1

Sum({<flag1={1}>}Qty) = 6 --> I received 0.
Sum(Qty) when filtered on flag1=1 --> I received 0.

My final KPI should be like that:
Avg(Aggr(Sum({<flag1={1}>}Qty),Date))

Thanks!!

Show Less

High Five

Meet Maxime

Our featured member for May 2024

Leaderboard

Heinvandenheuvel

igoralcantara

Lech_Miszkiewicz

rwunderlich

marcus_sommer

Asokan

Popular Resources

View All

Customer Story

Qlik Data Integration & Qlik Replicate story

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.