Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 245,648 members
  • 2,080 online
  • 2,028,987 posts
  • 152,684 Solutions
Announcements
See why Qlik was named a Leader in the 2025 Gartner® Magic Quadrant™ for Augmented Data Quality Solutions: GET THE REPORT

Welcome to Qlik Community

Recent Discussions

  • No Boards Found
  • forum

    App Development

    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 More

    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(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.

     

    image (8).pngimage (7).png

     

     

    Show Less
    Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
  • forum

    App Development

    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 More

    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, 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

     

     

     

    Show Less
    Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
  • forum

    Visualization and Usability

    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 More

    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 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!

    Show Less
    Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
  • forum

    App Development

    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 More

    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({<$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)))

    Peony_0-1742073664574.png

     

    Show Less
    Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
  • forum

    Application Automation

    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

    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.

     
     
     
    Show Less
    Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
  • forum

    App Development

    How to download Qliksense Desktop Free version

    How to download Qliksense Desktop Free version
    Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
  • forum

    Qlik Compose for Data Lakes

    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 More

    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’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 🙂

    Show Less
    Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
  • forum

    Qlik Cloud Data Integration

    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 More

    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 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

    Show Less
    Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
  • forum

    App Development

    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 More

    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 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

    Vaishnav16_1-1741780664797.png


    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


    Show Less
    Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
  • forum

    App Development

    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 More

    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. 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.

    Fight4Freedom_1-1741954926109.png

     

    Fight4Freedom_2-1741954991938.png

    Show Less
    Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Weekly Leaderboard

Customer Story

Optimizing Food Relief with Qlik

Qlik empowers Foodbank Victoria with real-time data insights, optimizing food acquisition and distribution to deliver 25 million meals annually while reducing waste and costs across its statewide relief efforts.

Location and Language Groups

Choose a Group

Join one of our Location and Language groups. Find one that suits you today!

Collaborate

Blogs

Community News

Hear from your Community team as they tell you about updates to the Qlik Community Platform and more!