Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 247,433 members
  • 6,402 online
  • 2,030,274 posts
  • 152,832 Solutions
Announcements
April 9th: The AI Roadmap: 6 Landmarks for AI-ready Data and Analytics: REGISTER NOW

Welcome to Qlik Community

Recent Discussions

  • forum

    New! Qlik Answers

    If statement with date

    Hi I have a text box that contains the following if statement =if (DATE(TODAY() - MOD(WEEKDAY(TODAY()) + 2, 7) - 1, 'DD/MM/YYYY') = DATE(MAX(FLOOR([JO... Show More

    Hi I have a text box that contains the following if statement


    =if (DATE(TODAY() - MOD(WEEKDAY(TODAY()) + 2, 7) - 1, 'DD/MM/YYYY') = DATE(MAX(FLOOR([JOB_DATE])), 'DD/MM/YYYY'), '', 'ALERT *Missing Fridays Data for jobs')  

     

    which was supposed to warn for missing data on a friday. but this only works the following day because the max wont be that day so i tried to do it with a count

     

    =IF(Count({<JOB_DATE = {"$(=DATE(TODAY() - MOD(WEEKDAY(TODAY()) + 2, 7) - 1))"}>} JOB_DATE) > 0, '', 'ALERT *Missing Fridays Data for jobs')

     this didnt work because JOB_DATE contains date and time.
    but floor doesnt work in the count so this doesnt work at all 😞

    =IF(Count({<Date(Floor(JOB_DATE), 'DD/MM/YYYY') = {"$(=DATE(TODAY() - MOD(WEEKDAY(TODAY()) + 2, 7) - 1))"}>} JOB_DATE) > 0, '', 'ALERT *Missing Fridays Data for jobs')



     

    does anyone have an idea how to fix this? seems simple but i have run out of solutions 

     

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

    Talend Studio

    AWS KMS Encryption Decryption in talend

    Hi, I have a use case where we are receiving the AWS KMS encrypted file in s3 and this file i have to decrypt in talend for data load. Has any one eve... Show More

    Hi, I have a use case where we are receiving the AWS KMS encrypted file in s3 and this file i have to decrypt in talend for data load. Has any one ever worked around it ?

     

    Thanks

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

    GeoAnalytics

    How to aggregate superposed areas in a single area while conserving their inters...

    Hello,I need to add a new layer to a map made of the aggregation of multiple areas.The areas are based on a radius of 40km of multiple coordinates (th... Show More

    Hello,

    I need to add a new layer to a map made of the aggregation of multiple areas.

    The areas are based on a radius of 40km of multiple coordinates (the coordinates are the location of some customers), which I was able to generate for each customer using qlik script. (see below)

    marcusva_0-1743085492985.png

    I tried to use the GeoAggrGeometry() function to create the new polygon aggregating all areas, however it seems that the function cancels out any intersection between areas. Since I have customers that are very close to each other, I can't get a map with a full single merged area.(see below)

    marcusva_1-1743085539258.png

    Does anyone know if there's a workaround this issue or another way to get the expected result?

    Thanks in advance for any information that may help!


    reference: https://help.qlik.com/en-US/sense/November2024/Subsystems/Hub/Content/Sense_Hub/Scripting/GeospatialFunctions/GeoAggrGeometry.htm

     

     

     

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

    Integration, Extension & APIs

    read app tags in Qlik Cloud

    I would like an Qlik Application Automation to read the tags that are saved at app level. Is there a way to do that?  See example below:     Show More

    I would like an Qlik Application Automation to read the tags that are saved at app level. Is there a way to do that? 

    See example below:

    coengiesberts_anva_0-1719307046008.png

     

     

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

    Visualization and Usability

    Label and data value together in a pie chart

    Hi All,  I  have a donut chart and the labels are male and female. Now the data values are coming inside the donut chart and the labels are outside th... Show More

    Hi All, 

    I  have a donut chart and the labels are male and female. Now the data values are coming inside the donut chart and the labels are outside the donut chart. Is there any way i can put data values under the label. So i am looking for Female(22.11K) and Male(37.47K)

    Pragya_0-1659479257742.png

    Thanks

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

    New! Qlik Answers

    Help with stacked bar chart

    I have a dataset with a column called Products with five types of products, from which I only need to represent three in a stacked bar chart. (Those p... Show More

    I have a dataset with a column called Products with five types of products, from which I only need to represent three in a stacked bar chart. (Those products are shirts, shoes and dresses)

    I also have five columns Q1,Q2,Q3 , Q4 and total yearly

    The stacked bar chart should have in the x axis the Q1, Q2, Q3  Q4 and total yearly, and in the barst the three types of clothing should be represented.

    As far as I know, I need to pivot or unpivot those three columns? Something related to taking the resident table?

    I am a little lost and i would appreciate any help..

     

    attached u will find a pic of what i need, the quality of the drawing is not good, but i guess u get the idea 🙂

     

    thanks

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

    Visualization and Usability

    How to make a horizontal excel type table

    Hello, Looking for ideas on how to make a table look similar to this where it's more landscape based... 
    Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
  • forum

    Application Automation

    Incremental Load using where clause

    Suppose I have a employee data. First I generate the QVD's. When i start to perform incremental load on QVD's using API's so i want only change data a... Show More

    Suppose I have a employee data. First I generate the QVD's. When i start to perform incremental load on QVD's using API's so i want only change data add in the QVD based on employee ID.
    How to solve this problem?

     

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

    Application Automation

    Qlik sense Automation

    Hi, I couldn't send mail by generating the report of an app to pdf. It shows the following error. How to rectify it? error: json_encode error: Malfo... Show More

    Hi, I couldn't send mail by generating the report of an app to pdf. It shows the following error. How to rectify it?

    error:
    json_encode error: Malformed UTF-8 characters, possibly incorrectly encoded
    Show Less
    Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
  • forum

    Visualization and Usability

    SimpleFieldSelect Extension scrollbar freezes on clearing the selection

    Hello Team, We have one extension object(SimpleFieldSelect) used in our dashboard where we have scroll in our report sheet/Page when ever we clear the... Show More

    Hello Team,


    We have one extension object(SimpleFieldSelect) used in our dashboard where we have scroll in our report sheet/Page when ever we clear the filter selection from this field selection from dropdown.

    We have already used in our existing dashboard but as per old requirement we did not have any scroll in our report. now as per new UI we have many options and user selection due to that we have scroll in our landing page .I have observed that if we clear selection from "Simple Field Select" extension scroll bar freezes , get stuck and it does not allow to scroll down or up UI get freeze at the same state.

    Please provide solutions if someone faced similar issue.

    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!