How to implement custom properties in a load balancing rule for a Scheduler, where any tasks that applications have these custom properties run only on the designated node.

Ex.:

I have this scenario, Node Central and RIM. Some applications need execute task (schedule resource) in a RIM node e others in Central Node.

App A > Consuming resource for this node Central.

App B > Consuming rosource for this RIM.

Doing custom properties for a separete an level the app, only resource engine forwad for RIM, anyway task in QMC have a priority execute in Central node first.

This is possible? Managed where this task is executed and consumition resource for node RIM?

Hi all,

Please, can anyone explain or send me a link that explain step by step on how to us VB Script Macros to Send email through Outlook In QlikView?

Thanks 

Hi all,

I need to fetch the image from the excel source. and I need to display the image in front-end table respective to ID field.

Its an high priority task, Assist me as soon as possible.

Thanks in advance! 

Qlik Cloud  

#

I need to multiply the value 300,000 in column 2 * the Rank(Relative). But I can't get the correct value.

What would the set analysis look like between column 2 * column 3?

Hi, I am working on Qlik Sense Desktop and currently developing a Ad-Hoc combo chart with VizLib combo chart extension and users can select the dimension(s) and measure(s) to be displayed on the combo chart. I have 2 filter panes, one is for dimension and one is for measure. In order to filter out unselected dimension(s) or measure(s), I used calculated conditions in the data section. I have both integer values (in millions) and percentage values for the measures, thus, I used the primary y-axis for the integer values and secondary y-axis for the percentage values. The combo chart displays the bars and lines correctly when I have both measures from primary and secondary axis selected or just measures from the secondary axis (which are the percentage values). When I only have measures from the primary axis selected, weirdly, the values in the primary axis alongside the lines or bars will be displayed too high and are not visible within the chart. The range of the values on the primary axis are all off, it will only work if I set the Min/Max values manually but its not practical. I set all the formatting to auto for all the measures and the problem still persist. Is there a way to make the chart's axis display the values range dynamically or is there some settings that I missed from VizLib combo chart? Any help would be greatly appreciated. 

Source is SQL MS-CDC, we created full load + CDC task and perform DDL operation(add column) and Qlik replicate is captured that one.

Same operation we created when task in stopped state. Then we resumed the task,  then table got suspended. 

We tried to reload the table and task, while inserting a data in source and table got suspended. In that scenario, how should we run the task?

Hello,

I have this load script for one of my app in Qliksense.

Table1:

Load

First_Name,

Last_Name,

Salary,

Fiscal_Year

SQL Select

FirstName as First_Name,

LastName as Last_Name,

Salary,

FY as Fiscal_Year

From XYZ_Table

In the sheet, I have this simple table with Fiscal_Year column that shows all the data for all the years.

User requested to filter the data to only shows the current year and two previous years. I have adjusted my code to this:

Table1:

Load

First_Name,

Last_Name,

Salary,

Fiscal_Year

SQL Select

FirstName as First_Name,

LasrName as Last_Name,

Salary,

FY as Fiscal_Year

From XYZ_Table

WHERE Fiscal_Year >= (YEAR(GETDATE())-2);   //to get only year 2024 and 2023,2022//

It loaded successfully and I got no errors, but when I go to my table in the sheet, I still see years from 2016-2021

I am not sure what I am missing. Could someone please help me with this?

thank you!

Hi ,

Can you give some example how to gives access group level qlik sense section access.

I have some requirement like below:

let's we have Total 6 user: They are divided into 2 Group.

How to Give access 2 group different level country access.

ex: 1st group need IND,USA access 

     2nd  group need UK,AUS access

I have provided the Data below

Sales:
Load * inline

[

Year, COUNTRY,Sales
2019, IND, 100
2020, IND, 200
2021, IND, 300

2019, USA, 120
2020, USA, 220
2021, USA, 500

2019, UK, 350
2020, UK, 650
2021, UK, 150

2019, AUS, 850
2020, AUS, 750
2021, AUS, 450
];

Hi all,

I'm using QRS API to create users in Qlik Sense on-prem version via code.

Now I have a new requirement to update user id, It means I need to find existing user in Qlik and update his userid.

Is it possible to do it using QRS API? I found this reference but I think it's only relevant for Qlik Cloud:

https://qlik.dev/apis/rest/users/#%23%2Fentries%2Fv1%2Fusers%2F-userId-patch

Thanks,

Eli