Can we create custom banner in Qlik Saas.

We have to display message on Hub if there is any planned maintenance or data refresh failure. 

This facility is available in Enterprise version. But didn't find on qlik SaaS.

Hei,

I have somewhere seen an object that could hold a lot of values like a table. 

Every measure could be written separately.

How you please help me out?

P.S. Qlik Sense on prem version

Hi All,

How to sort data based on leading zeros and not the actual number in qlik

Below is my example

The data should be sorted based on number of zeros at the start in ascending order.

My final output should be like the below table

Note : This is just an example . I have more that 30000 item numbers like this and i want to sort based on number of leading zeros

Hi Everyone, so I have geo map which shouldn't affect when I select year month, So I have provided the expression to ignore this dimension but in size&shape properties, there are two layers point layers and area layers, except size&shape all the properties are dimension, so How should I stop the dimension from reflecting from year-month?
right now after selecting it is removing countrys(area layer) and some station(point layer) when I select year-month.
Used expression: SUM({<[YEAR_MONTH]=>}[GEO_AVG_PRICE] * [GEO_QTY])

Before selecting year month filter:

after selecting (it shouldn't change anything, It should show the map as it was before as in above image):

Hi All,

I have sheet and i want to add images as sheet background. there is no option in sheet properties in my current version in my organization.

I am trying to add using html and css but it's not working properly.

.qv-panel-sheet {
background-image: url("C:\Users\Desktop\1600w--kbTNqEWceg.png");
}

Can you please suggest me how to do this scenario in Qliksense.

Thanks & Regards,

Lakshman 

we are able to connect Mongo DB atlas from our remote server from mongosh but when we are trying to connect from talend tool we are getting below error. even we tried with replica host in tmongodbinput component but does't works. 

Exception in component tMongoDBInput_1 (RERUN_MONGO_GL_EXPORT_JOB_PRD_REVENUE_FIELDS)
com.mongodb.MongoTimeoutException: Timed out after 30000 ms while waiting to connect. Client view of cluster state is {type=UNKNOWN, servers=[{address=pl-0-ap-southeast-1.o7dng.mongodb.net:1024, type=UNKNOWN, state=CONNECTING, exception={com.mongodb.MongoSocketReadException: Prematurely reached end of stream}}]
        at com.mongodb.internal.connection.BaseCluster.getDescription(BaseCluster.java:179)
        at com.mongodb.internal.connection.MultiServerCluster.getDescription(MultiServerCluster.java:54)
        at com.mongodb.client.internal.MongoClientDelegate.getConnectedClusterDescription(MongoClientDelegate.java:136)

I have created a bar chart with data that drills down. I am having problems with calculations in that chart. There are two filters, the bigger one is sports and the smaller one is athletes. Given the 5 biggest athletes in a few major sports, I want the chart to show a % of pay each of those athletes gets out of the sum of all 5 athletes.

My current code looks something like this:

Sum(Athletes_money)/sum(total Athletes_money)

This works when a specific sport is chosen, but when no filter is chosen and the bar chart shows all sports separate, the individual athletes money is divided by all of the athletes that are in the filter. Is it possible to make the denominator the total of just the athletes sports grouping instead of all athletes?

I am Trying to do CDC Load with ODBC Connection, After selecting the tables when i am trying to run the job it gets failed with below error.

Creating Metadata Manager's utility components failed
Cannot create the source utility component
Failed while preparing stream component 'QAD_PERU'.
Context field(s) are not defined

Attaching the log screenshot.