Hi!

I have a dashboard with 2 excel tables in the contents (Table 1 and Table 2). I need to do some KPIs, summarizing, values from table 2, but just the ones that belongs to a list of people in Table 1. The field that I need to use to compare between 2 tables is the "key" between the tables. Is there any way or formula I can use to do that conditional exercise. 

Is it clear? Can maybe I build a new table from the 2 existing ones?

Thank you! 

 

Show Less

Hi,

I am trying to get zero value to be shown in the line chart. I have created a pivot table for the same data that I want to show in line chart. For the year 2024, 2023, 2022 i have created columns and the 2024 column contains zero value for the region for specific month. The same is done in line chart but the zero value for not shown in the line chart.

I have tried toggling all the options under missing data, but nothing worked. 

Qlik Enterprise Feb 2024

 

 

Show Less

Hi all,

My Qlik Cloud OneDrive data source connection was working properly, and then all of a sudden, my reload tasks started failing & when I try to extract data from any of my existing files in it, I am getting this error message 

I can still access the OneDrive folder from the load script & see my files. But when I try to pull any one of them in, I am receiving that error message.

Any knowledge on how & why this is happening?

Thank you

 

Show Less

Dear gurus 

There are so many similar posts in here but try to understand it may takes some time. Hence i decide to post it here using my table.

I have 2 tables - Staff and Form_Submission. Both table contains column 'Name' and 'UserIds'

In the load editor how am i suppose to write the script so that i want to know which staff in table Staff has never submit a form. I saw lots of example using Not Exist. Just hope that someone can help me by using my scenario here . TQ ! 

 

Show Less

We have created a custom theme in Qlik. This has been working, until yesterday when the theme suddenly stopped being applied, and a default Qlik theme is set instead. This is strange and unpredictable behavior and curious why our previously functioning custom theme, all the sudden stops being applied. The theme is uploaded based on the JSON-file code below. This has been tested and validated in JSON-validator too. Can there be any other issues with the code? Or why can a theme all the sudden stop being applied?

 

Show Less

I have a field for postal code, latitude, longitude, state and city. The latitude and longitude is based on the center of the postal codes. I want to be able to create a filter that pushes the data out to include other zip codes by their lat/lon coordinates based on whether the user selects 5, 10, 20, 25 or 50 mile radius. Is this possible in Qlik with the data I have available to me?

Show Less

Source: On-Prem SQL server

Target: Azure SQL server

We are copying 196 tables from source to target. For whole night it was running fine. Full load and Change processing was perfect over a night.

Suddenly we encountered this error.

 

Show Less

Hello,

I have a data set of 1.3 million rows. For a lot of the visuals I require a long table so when i create a long table it produces 153 million rows. The widgets have a hard time loading that much data especially when the widget is using the long table. the long table gives me what im looking for in the visuals but the widget loading is really bad, Is there any other options that has the same functionality of the long table? 

Show Less