It seems that App.SetScript
is clearing your load script because it may be replacing or resetting the current script when it's called. To prevent this, make sure you're appending or modifying the script instead of completely overwriting it. Double-check the implementation to ensure you're not unintentionally removing or clearing existing code.
Recent Discussions
-
sum values group by ID
Hi guys,I have a table with ID, Suppliers, and Values. In the front end, I need to sum the Values by ID desconsidering suppliers. I tried to use sum(A... Show MoreHi guys,
I have a table with ID, Suppliers, and Values. In the front end, I need to sum the Values by ID desconsidering suppliers. I tried to use sum(Aggr(sum(Values),ID)), but it is not correct. How can I do this? In this example, I need to show 100 because ID 1100 has a value of 100 and not 200.
-
Identify all customers who have not made any revenue in the past two years.
Hi,i have a question regarding E() in Set analysis:I have the following data set:LOAD date(Date) AS Date, Customer, Sales, Product Inline [Date, Custo... Show MoreHi,
i have a question regarding E() in Set analysis:
I have the following data set:
LOAD date(Date) AS Date, Customer, Sales, Product Inline [
Date, Customer, Sales, Product,
01.01.22, 1, 100, Shoe
01.01.25, 1, 200, Shoe
01.01.25, 2, 200, Shirt
];sum({<Customer= E({1<[Date] = {">=$(=AddYears(Today(),-2))"}>})>} Sales)
Identify all customers who have not made any revenue in the past two years.
I would expect Customer 1 as output but it doesnt work.
Best regards
Son
-
Comparison between months using set analysis
Hi everyone,I need to create a line chart that compares each month to its previous month.The dimension is Year-Month (format: YYYY-MM).The metric shou... Show MoreHi everyone,
I need to create a line chart that compares each month to its previous month.
The dimension is Year-Month (format: YYYY-MM).
The metric should be the quantity of the month compared to the quantity of its previous month. There is a master measure called CountX that can be used.For example:
The model is filtered for the year 2025.
CountX for February 2025 is 100, for January 2025 is 80, and for December 2024 is 95.
Then in January 2025 I should see -15 (80-95), and in February 2025 I should see 20 (100-80).I tried using the Above function, but I am not getting data for January 2025, probably because December 2024 doesn't meet the filter criteria.
I couldn't solve it using set analysis.I would appreciate any help.
Thanks! -
An issue with a variable with parameter
Hi all. Please, could anyone give a piece of advice regarding an issue described below. I created a variable with parameter v_Total_Dollar_Sales = Sum... Show MoreHi all. Please, could anyone give a piece of advice regarding an issue described below.
I created a variable with parameter v_Total_Dollar_Sales = Sum({<$1>} Dollar_Sales).
Also, I created a variable with list of fields that should be applied to $1 parameter v_Chicken_Dim_Total_Exclude = '%Chicken_Brand=, %Chicken_Segment=, %Chicken_Retailer=, %Chicken_Subcategory='
But when I applied it only %Chicken_Brand appeared in set analysis. Why is it so?
=$(v_Total_Dollar_Sales($(v_Chicken_Dim_Total_Exclude))) -
App.SetScript clearing my load script
It seems that App.SetScript is clearing your load script because it may be replacing or resetting the current script when it's called. To pre... Show More -
How to download Qliksense Desktop Free version
How to download Qliksense Desktop Free version -
Random Compose Error: SYS-E-HTTPFAIL, No such task id: xxxxx
Dear Experts, We have randomly encountered Compose Error: SYS-E-HTTPFAIL, No such task id: xxxx. The error comes and goes for different tasks. I didn... Show MoreDear Experts,
We have randomly encountered Compose Error: SYS-E-HTTPFAIL, No such task id: xxxx. The error comes and goes for different tasks. I didn’t try to fix them, the next time the task ran sometimes it was ok again or the error went on a different task. Our Compose is 2024.12.0.21 version.
Any response will be greatly appreciated.
Thank you 🙂
-
How to reload a project using the API
Hello team,I am executing the "Start a project task" API at the URL below, but it seems to resume from CDC.https://qlik.dev/apis/rest/di-projects/I wo... Show MoreHello team,
I am executing the "Start a project task" API at the URL below, but it seems to resume from CDC.
https://qlik.dev/apis/rest/di-projects/
I would like to perform a full load. Could you please tell me how to do this?
For example, by executing a different API or adding parameters.
Best Regards -
Alternative states instead of Tab Container in Qlik
Hello Guys,I am using tab container visual in qlik sense to show multiple objects in a single visual and in filter pane added all the charts so that i... Show MoreHello Guys,
I am using tab container visual in qlik sense to show multiple objects in a single visual and in filter pane added all the charts so that if i select particular chart from filter pane it show only that visual in tab container
But now my user wants to see like : Please add a way to compare between charts
Below is how my current chart looks like
How can I do this any suggestions, can I try alternative way, if yes how to do?
How about using alternate states
can anyone please help me on this -
Calculating Teleworking Rate Based On Dates
Hi everyone. I have the leave start date, end date and leave day information which have been calculated on a sql table. Leave days are all networkdays... Show MoreHi everyone. I have the leave start date, end date and leave day information which have been calculated on a sql table. Leave days are all networkdays. I need to calculate teleworking rate for each month of year. (teleworking days / networkdays)
Some of them contain the same month like blue painted ones. So, It's easy to calculate how many leave days each month contains. But, orange painted ones' starts date and end date contain different month. I need breaking down leave days into months and unify and summarize on a monthly basis like second picture.
Thanks.