Hi All,

Currently we upgraded our Qliksense to May 2023 and after upgrading the Qliksense the Apache hive connection is not showing in New connection tab.

Please let me know is there any upgradation problem or Qlik removes the Apache hive connection. If they removes so how I can connect with Apache hive.

Thanks in advance.

Is it an absolute requirement to have a Data Movement gateway when using MSSQL server as source in QCDI? If the SQL Server is hosted in say Azure, why is there a need for a Gateway if the server is available to Qlik Cloud?

I get it for onprem servers, but cloud ones? I mean, there's no "Azure SQL Server" connector in QCDI, and no option for a "native" connection to an SQL Server (if available remotely).

I'm suspecting it has to do with the way QCDI wants to read from the database - either log or CDC based, but I don't fully understand why the Gateway can but not QCDI natively.

I installed 2018 Nov Nprinting(VMware) and installed 2018 Nov qlik sense in the other window server.

but... I got error...

What is the problem...???

The customer bought Nprinting license... So.. I must find this error's solution

Please help me....

Hi,

My apps contains of hundreds of users where users are grouped using custom properties (named as strGroups) that setup in QMC to control how each group of the user can access to app/objects in apps.

In my sheet, I have navigation button,  login user with strGroups = 'A' will see the button enabled but the same button will be disabled if login user is from other strGroups .

I have defined a variable in my load script to assign default value strGroups = 'A' but how to get the actual user group based on login user who access to my app?

Hi, I am trying to create a table chart that has months with 'MMM' format as dimension and Total Sales, Sales Last Month and Variance as expressions. The desired result will look something like this:

I have tried using Above() function for this case, it worked but is very limited in flexibility. The table will not worked if users made a selection like month. I have tried with expressions like:

SUM({$<Month = {"$(=Max(Month-1)"}>} sales) 

for the 'Sales Last Month' expression but instead of displaying previous month's sales, it just returns me the same values as in the 'Total Sales' column. I have looked at a lot of posts in this community but still can't find a solution for it. Can I know how can I create a table as above without using Above() function so it can still display the correct values if users made selections on month? Or is that possible?

Hello Community,

I am Created 1  dashboard & i want to create the section access.

In Raw DATA i have column 'Destination Country' so i change as UNIT

[Destination Country],
if(WildMatch([Destination Country],'*Thailand*'),'Thailand',
if(WildMatch([Destination Country], '*Indonesia*'),'Indonesia',
if(WildMatch([Destination Country], '*Singapore*'),'Singapore',
if(WildMatch([Destination Country], '*Vietnam*'),'Vietnam',
if(WildMatch([Destination Country],'*Malaysia*'),'Malaysia',
if(WildMatch([Destination Country], '*Cambodia*'),'Cambodia',
if(WildMatch([Destination Country], '*Laos*'),'Laos',
if(WildMatch([Destination Country],'*Myanmar*'),'Myanmar',
if(WildMatch([Destination Country],'*China*'),'China','Non-AT Countries'))))))))) as [UNIT],

I have Column UNIT in this there is multiple country please find below 

i am created section access but its not working please find below ( here work only user id and password for example HAMD open the application user id and password working properly but In UNIT show all Country instead of Thailand)

and i am also created below but its not work

Please Help me how I solve this Section access i just want to show HAMD Thailand ,kHNIN Singapore & CHILVERICC Laos.

Hi, 

I have recently started using Qlik sense cloud and we are using Qliksense November 2022 Patch 7 version of the app. When try to get the totals on top of a bar chart. The text for the total is not clearly visible. Sometimes it is not even readable. I've never faced this issue before but this has been the case ever since we moved to the cloud. 

Is there anything I can do to fix this? Please see the attached screenshot

Thanks in advance

Qlik Sense Business Qlik Cloud 

Hi

It's sql table varchar

Hi

It's sql table varchar

This working Sum( {<MonthYear={'$(=MaxString(MonthYear))'}>} QC_EvaluationResult)
but there will be no years and months for the columns
Month year is varchar sql table. How do I change the script to varchar to date.
If after this the formula could sum the values ​​per month

Hello,

How I can change the QLIK logo which is in the top left of a screen application please ?

The style image not working

 Thanks a lot for your help.

Regards,

Bruno