What platform or what way would you suggest to be the most inclusive way to create a custom theme for Qlik Sense Cloud?

For example, the one that can

• Use gradient as sheet title background color
• Add logo to on top of the sheet
• Customize grid line colors

I knew this should be possible because I have a custom theme with this features, but cannot export them (initially I want to export and edit the existing custom theme). So, I would like to try to build from scratch.

Looking forward to your suggestions. Thank you 

I really liked chart exploration in straight table chart recently added to Qlik sense. Can Qlik sense add this feature also to the official table chart?

Hello, 

A bit at a loss while trying to implement a specific set of actions on a button click. 

I have a table, i have some filters that can be applied. I have a button that selects just the ID after filters are selected and clear the rest of the filters. I want yet another button that does the opposite. It needs to exclude from the selected accounts from the previous selection. Using 'select exclusion' works, but for the whole table. The previous selection is overwritten. 

As in the picture attached, i want to use the filters to get a subset of the 7 ids already selected. Let's say number 1 and 3. The Exclude selection button should exclude 1 and 3 and lock the final selection to 2,4,5,6,7. At the moment it returns all IDs in the table(which ar emore than 7) except 1,3.

Any advice?

Thank you!

Hi,

we are facing this warning message when using the PATCH method in tRestClient:

WARNING: An illegal reflective access operation has occurred

WARNING: Illegal reflective access by org.apache.cxf.common.util.ReflectionUtil$11 (file:/C:/Program%20Files%20(x86)/Talend/studio/configuration/.m2/repository/org/apache/cxf/cxf-core/3.4.4/cxf-core-3.4.4.jar) to field sun.net.www.protocol.https.HttpsURLConnectionImpl.delegate

WARNING: Please consider reporting this to the maintainers of org.apache.cxf.common.util.ReflectionUtil$11

WARNING: Use --illegal-access=warn to enable warnings of further illegal reflective access operations

WARNING: All illegal access operations will be denied in a future release

We tried Open Studio and Studio Data Fabric with Zulu Version 11.

The patch is successfully executed but the warnings are still irritating.

With other methods (GET, POST, PUT) no warnings occure.

The design of the job is straight forward.

Any ideas?

Thanks

Ben

Hi,

I am looking to get different dimension values based on same ranking. So, I have created an inline view with Dim and Exp by assigning a value to each dim.

Load * Inline
[
dim, exp
'Style', '1'
'Colour', '2'
'Min Range of Month', '3'
'RRP', '4'

];

 And I am looking to bring the corresponding values thru if statement on Straight table

The below expression is not working as expected,

if(exp='1',only(if(Aggr(rank(sum(total <[Style Colour]> [Sales Amount]),4),[Style Colour]) = 1, [Style])),

if(exp='2', only(if(aggr(rank(sum(total <[Style Colour]> [Sales Amount]),4),[Style Colour]) = 1, [Colour])),

if(exp='3', only(if(aggr(rank(sum(total <[Style Colour]> [Sales Amount]),4),[Style Colour]) = 1, [Min Range Month])),
if(aggr(rank(sum(total <[Style Colour]> [Sales Amount]),4),[Style Colour]) = 1, Sum([Sales Amount]))
)
)
)

Can you please check my set analysis and advise why it's not working for other values. 

Thanks in advance.

Hi, I'm trying to connect SharePoint via Qlik Sense. Below steps i followed, 

1. Creating a new data connection. 

2. Choosing  the data source "Office 365 Sharepoint"

3. Then given the base URL of Office 365 Sharepoint in the baseURL.

4. Then choose the "None" from Prompt/Consent level. 

5. Click on Authenticate button. Then it will take to next tab and code generated. Then copied code and paste in the respective tab. Then clicked on the Authenticate tab. 

6. After that taking some time and faced the error. Below is the error message,

"error verifying: A connection attempt failed because the connected party did not properly respond after a period of time or established connection failed because connected host has failed to respond "Some IP (1.1.1.1:443)"

kindly suggest

Hi Team,

I have this below code to get the task list from QEM. 

# Define the URL for the API call
$url = "https://computer.network.net/attunityenterprisemanager/api/v1/servers/myrepsrv1/tasks"

# Prepare the headers for the API call, specifically the session ID
$headers = @{
"EnterpriseManager.APISessionID" = "wCo0_KvjEUFROvfHF5KGrw"
}

# Make the HTTP GET request and ignore SSL certificate validation errors
try {
$response = Invoke-WebRequest -Uri $url -Headers $headers -Method Get -SkipCertificateCheck

# Check if the request was successful (status code 200)
if ($response.StatusCode -eq 200) {
Write-Output "Tasks retrieved successfully:"
Write-Output $response.Content # Print the response content which includes the task list
} else {
Write-Output "Failed to retrieve tasks, status code: $($response.StatusCode)"
}
} catch {
Write-Output "An error occurred: $_"
}

how to find Session ID of QEM? Pls suggest.. Also I need last week task list using the same.

thanks

Vish123