I need to use the color for stacked chart based on the legend dimension value.

For example, if I show the sum value for month and Status in the stacked bar chart , the color of the bar should be based on the status value.

I used the below expression in the Appearance >> Color and Legend >> Use custom colors

=pick(Match(ErrorStatus,'Success','Service Unavailable','Bad Gateway'),'#009845','#004080','#F20000')

but its not working properly. If I made the selections in the status then the bar is appearing with the corresponding color but if there is no selection then the bar itself is not showing.

But if I scroll over the chart area the tooltip is appearing as normal.

Hi Team,

Ourt business is planning to upgrade the QlikView application.

From 12.7 to 12.8,

let us know if the 12.9 is releasing.in this May, and we should wait for this version. 

Hi ,

I have two dimesion  and we have used secondary dimensionality in measure to create a pivot table as shown

now based on selecting any dimension user wants the measure to be sorted in descending order please se the measure below.

 we have used dimensionality concept in our expression as shown below

Please let me know how to sort all measures if we select any one  dimension

thanks,

Suresh 

Hello.

I'm trying to move from iFrame to Qlik-Embed based on OAuth 2 authorization because my iFrame is not working properly (Embedding a chart doesnt work in Chrome/Incognito).

My goal is to see a Qlik Cloud sheet inside my Razor application. (This page is a single HTML with js in it)

The problem I'm facing with this approach is this:

- I'm able to log in and see the UI=classic/app version of the sheet but when i try doing it in UI=object or UI=analytics/sheet I don't get anything rendered.

I understand even though some of the graphics in the page may not be Nebuja.js I have to see the rest of the sheet.

Hi Everyone, so I have geo map which shouldn't affect when I select year month, So I have provided the expression to ignore this dimension but in size&shape properties, there are two layers point layers and area layers, except size&shape all the properties are dimension, so How should I stop the dimension from reflecting from year-month?
right now after selecting it is removing countrys(area layer) and some station(point layer) when I select year-month.
Used expression: SUM({<[YEAR_MONTH]=>}[GEO_AVG_PRICE] * [GEO_QTY])

Before selecting year month filter:

after selecting (it shouldn't change anything, It should show the grap as it was before as in above image):

Hello.

I'm following these steps to use an IFrame to embed in my Razor Application a Qlik Cloud Sheet. 

Qlik Sense Enterprise SaaS: How to embed a chart in an iFrame  

From @Damien_Villaret 

I'm moved to the login page in Chrome, and redirected back to my page where I can see the embedding content with no problem. But, in Firefox or Incognito, I got stuck in a loop where it keeps getting 401 from the /users/me endpoint and the login page returning 302 (It seems like I'm already logged in and I'm redirected back to the returnTo value) but never popping the login page.

There are no errors in console related to this process apart from the 401.

P/D: I'm also trying to implement Qlik-Embed with OAuth, but right now I'm only able to see the classic/app version of it, as soon as I put an object or analytics/sheet I get a full empty page with no content. Some of the graphs are not Nebuja.js but I understand that I should be able to see at least the page content rendered. 
I opened another question about this and link it here, but this post is the most important for me right now as my requirements include sending some variables to the sheet that I cannot do with qlik-embed.

when we are trying for CDC Load for ODBC connection the job is getting failed with below errors.

Error 1: 

Stream component 'st_0_QAD_PERU' terminated
Cannot initialize subtask
Failed while preparing stream component 'st_0_QAD_PERU'.
Failed to prepare sqlite statements for CAPTURE MODE
Failed to prepare statement - select confirmed_ctx from confirmations where table_id=? -  
SQLite general error. Code <1>, Message <no such table: confirmations>.

Error 2 :

Stream component 'st_0_QAD_PERU' terminated
Stream component failed at subtask 0, component st_0_QAD_PERU
Error executing command
Failed to init cdc table table 1
Unable to get column_def for context Field 0 of table 1

Attaching the logs for both Error

I have a table with 100 columns

I want to check for column 1 = 'ID001' if the other 99 columns has a certain date value say '2025-01-01'

But my code is throwing the error fieldname not found in the for loop...

what i did

// first filter column 1 for ID001

[TEST]: NoConcatenate LOAD Distinct * Resident[MAIN_TABLE] where column1='ID001';

// Loop to check for date value =  '2025-01-01' if have flag as 1

For f = 1 to NoOfFields('TEST')
LET F1 = FieldName($(f), 'TEST');
[Fields]:
Load distinct FieldName($(f), 'TEST') as Field, If(Date(Floor($(F1)))=Date(Floor(' 2025-01-01')),1,null()) as check
AutoGenerate 1;
Next f
DROP Table[TEST];

Any idea how to solve? Thanks in advance!

Olá.

Por favor, há alguma solução de somase para o caso?

Tenho uma tabela com campo "NF", "NF vinculada", "Operação" e "Frete".

Operação há dois valores "Receita" ou "Remessa".

O valor do frete está ligado às notas de "remessa", mas preciso trazer a soma dos fretes junto às respectivas notas de "Receita".

Há menção da respectiva nota de "receita" para cada nota de "remessa".

Obrigado.