Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 252,230 members
  • 6,085 online
  • 2,034,265 posts
  • 153,165 Solutions
Announcements
Qlik Launches Open Lakehouse and advanced agentic AI experience in Qlik Answers! | LEARN MORE

Welcome to Qlik Community

Recent Discussions

  • No Boards Found
  • forum

    Visualization and Usability

    Upper function failed

    Hi , the below expression is ok.however, if I use upper function, it failed.Count({<[Order Type Mini]={"<200"},[Order Type Mini]={">0"},upper([Order P... Show More

    Hi , the below expression is ok.

    emilyrabbit_0-1748500683566.png

    however, if I use upper function, it failed.

    Count(
    {<[Order Type Mini]={"<200"},[Order Type Mini]={">0"},upper([Order Purchase Order Number])={'*TQBH*'},[Order Type Code]={'ZSTD','ZTTB'},[Fact_Type]={'FACT_ORDER'}>}
    distinct [Order Document Number]
    )

     

      why and pls help me check it .

    emilyrabbit_1-1748500752985.png

     

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

    App Development

    Qlikview Pivot Table Column doesn't show

    Hi, I made a modification to a QlikView app, adding a column to a pivot table, but there is a user that can't see the column, other users can. I thoug... Show More

    Hi, I made a modification to a QlikView app, adding a column to a pivot table, but there is a user that can't see the column, other users can. I thought that the problem are the cookies of the browser, but the user logged in another PC and happend the same thing. Please help me.

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

    Application Automation

    License deallocation using automation in Qlik Cloud Analytics

    Hi,does any one has idea how to deallocate the license for user using Raw api request block in qlik cloud analytics. Regards,Siva Prasad
    Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
  • forum

    Integration, Extension & APIs

    Start the Qlik Sense QMC job from another server using PowerShell script.

    Hi Team,We have one Dummy Qlik Sense QMC job that is dependent on another server job where we are receiving the data. The QlikSense QMC job will be ex... Show More

    Hi Team,

    We have one Dummy Qlik Sense QMC job that is dependent on another server job where we are receiving the data. The QlikSense QMC job will be executed after the data has been refreshed from another server.

    We have PowerShell script which is running fine in old server but when we trying to execute this PowerShell in newly migration server. Getting forbidden error.

    Please find my script below.

    cls
     
    $hdrs = @{}
    $hdrs.Add("X-Qlik-xrfkey","iX83QmNlvu87yyAB")
    $url = "https://Myserver/qrs/about?xrfkey=iX83QmNlvu87yyAB"
    #$response = Invoke-RestMethod  -Uri $url -Method Get -Headers $hdrs -SessionVariable websession
    $response = Invoke-RestMethod -UseDefaultCredentials -Uri $url -Method Get -Headers $hdrs -SessionVariable websession
    $cookies = $websession.Cookies.GetCookies($url)
     
    $session = New-Object Microsoft.PowerShell.Commands.WebRequestSession
    $session.Cookies.Add($cookies)
    $response = @{}
     
    $hdrs = @{}
    $hdrs.Add("X-Qlik-xrfkey","iX83QmNlvu87yyAB")
    $url = "https://Myserver/qrs/task//start/synchronous?name=DummyJobForTrigger&xrfkey=iX83QmNlvu87yyAB"
    $response = Invoke-RestMethod -WebSession $session -Uri $url -Method Post -Headers $hdrs -ContentType 'application/json'
    $response.value -like "????????-????-????-????-????????????"

    Error screenshot:

    jrathgebercs_0-1748498174378.png

     

    Could you please check and suggest ?

     

    Regards,

    Irshad Ahmad

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

    App Development

    Variable Not Working After Publish Qlik Sense App

    New install of Qlik sense, new deployment.I have a dashboard with a variable that works before published. when i publish it, the variable stops workin... Show More

    New install of Qlik sense, new deployment.

    I have a dashboard with a variable that works before published. when i publish it, the variable stops working. others have reported this issue with no resolution, any ideas??

    Shouldn't the app be EXACTLY the same pre-deployment as post-deployment??

    -David

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

    Connectivity & Data Prep

    how to add a condition column in the loading script

    HI, below is my origin data. there are different product in each orderin the loading script , I want to add a new column , if the product contain 'cat... Show More

    HI, below is my origin data. 

    there are different product in each order

    in the loading script , I want to add a new column , if the product contain 'cat' ,and the order should be remark as 'cat order' . I wonder if I can use mapping load or left join. but I am not familiar with these 2 expression. Pls help me on it, thanks.

    emilyrabbit_0-1748418413493.png

    below is the target :

    emilyrabbit_1-1748418433497.png

     

     

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

    Visualization and Usability

    Concatenate two rows with overlapping data

    Hi, How can I concatenate two rows that have overlapping data and only concatenate the unique data from both rows? For example the first row is 'QIBOT... Show More

    Hi, 

    How can I concatenate two rows that have overlapping data and only concatenate the unique data from both rows?

     

    For example the first row is 

    'QIBOTH-Q1D|QFRTF'

    and second row is 

    'GPCQIBOTH-Q1D|QFRTF'

    I want the final result to just be 

    'GPCQIBOTH-Q1D|QFRTF' as the second row already contains all the data from first row and just has 'GPC' as extra data. 

     

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

    App Development

    Defect: Shaded areas on Qlik Sense Maps include internal area

    Do you have any idea how we could go about resolving/investigating below? I’ve checked all I can within Qlik Sense and I can’t see a way of working th... Show More

    Do you have any idea how we could go about resolving/investigating below? I’ve checked all I can within Qlik Sense and I can’t see a way of working this. It might be a limitation of the map object (current patch, potentially future patch)

     

    Otherwise, can you reach out to the vendor for help resolving an issue with Qlik Sense Map objects? Online research does not identified this as a known defect, resolved in a previous patch.

     

    Problem: When an area defined by a KML is shaded, different areas fully enclosed are shaded as well.

    Testing: Same behaviour regardless of KML file, level of thinning, region selected, app used and environment used. If any area is full surrounded by multiple selected area this does not occur, it only occurs when a single area fully encloses an interior area or area(s).

    Example: Eden-Monaro is the selected area, and thus coloured green. ACT is not in the selection yet is also coloured green (Should be transparent, revealing the yellow layer below).

    HI6_0-1748493074227.png

    Object: Map, Area Layer

    Version:  Qlik Sense November 2024 Patch 10 - qliksenseserver:14.212.17
    The problem is there since Qlik Sense Enterprise November 2021 Patch 12

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

    Qlik Replicate

    Inquiry on Retaining Existing DB Passwords When Importing Tasks in Qlik Replicat...

    Dear Qlik Support Team, We are currently planning to migrate Qlik Replicate tasks to another environment, such as UAT. During this process, we would l... Show More

    Dear Qlik Support Team,

    We are currently planning to migrate Qlik Replicate tasks to another environment, such as UAT. During this process, we would like to confirm whether it is possible to retain the existing database connection passwords that are already configured in the UAT environment when importing tasks from another environment (e.g., DEV or SIT).

    Specifically, we want to avoid overwriting the UAT database connection passwords with those from the exported task file.
    Is there an option or best practice in Qlik Replicate to preserve the existing DB passwords in the destination environment during the import process?

    Your guidance on this would be greatly appreciated.

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

    Connectivity & Data Prep

    Installed certificates are valid to connect to Qlik Sense

    Hi All,I need some assistance with setting up Qliksense certificates in NPrinting. I have so far managed to to have everything working but cannot seem... Show More

    Hi All,

    I need some assistance with setting up Qliksense certificates in NPrinting. I have so far managed to to have everything working but cannot seem to understand why I keep getting an error for valid certificates. I followed all required steps from exporting certificates from QS using an admin user account to placing them into the required folder in NPrinting server but I still get the error.

    I followed the below links:

    https://help.qlik.com/en-US/nprinting/May2021/Content/NPrinting/DeployingQVNprinting/NPrinting-with-Sense.htm#InstallingQlikSenseCert

    https://help.qlik.com/en-US/nprinting/May2021/Content/NPrinting/Troubleshooting/NP-wont-read-QS-certificates.htm

    What could I be missing here?

    ZeeGuy_0-1748329485386.png

    Qlik NPrinting Qlik Sense Business 

    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!