Prezados, 

Tenho um gráfico combinado 1 dimensão e 2 Medidas, porem preciso alterar as cores.

Dimensão: Mês/Ano

1º Medida: Relacionada ao valor de uma medição realizada mensalmente.

2º Medida: Meta, cujo a medição tem que alcançar.

A 1º Medida está em barra, preciso pintar a barra caso estiver abaixo da meta em vermelho, e igual ou acima em verde, já consegui fazer pela opção de cores por expressão. Porem a 2º medida que seria a meta, preciso deixar em outra cor, mas como estou usando a opção de cores por expressão o qlik por padrão deixa a 2º medida que está em linha da mesma cor.

Existe alguma maneira de deixar a minha 2º Medica com outra cor?

Segue print do gráfico combinado.

Hi everyone,

I am facing an issue as I am trying to build a flat file to import data in a software (standard format defined by the software editor). For each of my records, I have to go through several outputs I created and this order must be respected. At the moment, my job goes through the first output for all the records and then switches to the next output.

In my case, I would like it to go through each output, one by one, with one record before it switches to the next record.

How can I do this ? Please find attached a screenshot of my job.

Thanks.

Hi!, reading documentation about Qlik Web storage provider 'Google Cloud Storage', it says that you only can put data into a bucket in Qlik SAAS, are there any plans to have this in Qlik Sense Enterprise?

Storing data from your Qlik Sense app in Google Cloud Storage

You can store table data into your Google Cloud Storage bucket in the Data load editor. You can either create a new load script or edit the existing script.

https://help.qlik.com/en-US/connectors/Subsystems/Web_Storage_Provider_Connectors_help/Content/Connectors_StorageProvider/Storage%20provider%20connectors/Google-Cloud-storage-provider-connector.htm

Hi everyone,
I have this bar chart of the number of requests per quarter year.
There is a clear ascending linear trend that I want to visualize with a trend line. The "naive" built-in trendline from Qlik Sense is biased by the incomplete data of the current, incomplete quarter year as shown in the figure. The reasonable thing to do is to base that trend line on the years before YearStart(Today()).
I guess this is a pretty common thing, but I can't figure out how to implement this. Do you have a hint?

What I tried so far:

• Checking similar topics here and there.
• To calculate the intercept and slope of the regression line, I use Linest_B() and Linest_M().
• As X values, I use numeric value of the quarter year: (Num#(Left([Reception YearQuarter],4))+(Num#(Mid([Reception YearQuarter],7,1))-1)/4))
• As Y values, I use Aggr(Count(RequestID), [Reception YearQuarter]) over the set of Reception Dates from previous years {1<[Reception Date]={"<$(=Date(YearStart(Floor(Today()))))"}>}, or as a complete expression: Aggr(Count({1<[Reception Date]={"<$(=Date(YearStart(Floor(Today()))))"}>} RequestID), [Reception YearQuarter]).
• In a table showing Reception Year-Quarter (both text and numeric) and Count(RequestID), I succeed in correctly calculating Linest_B(Y values, X values) and Linest_M(...) as additional measures, but not Linest_B(...) + Linest_M(...)*X-value
• As a reference line this does not work either.

AggregatedSampleData:
LOAD * INLINE [
Reception Year-Quarter, Count
2021-Q1, 17871
2021-Q2, 17515
2021-Q3, 16443
2021-Q4, 19041
2022-Q1, 19297
2022-Q2, 18020
2022-Q3, 16881
2022-Q4, 19582
2023-Q1, 21232
2023-Q2, 19139
2023-Q3, 18494
2023-Q4, 21002
2024-Q1, 21784
2024-Q2, 1790

];

Tenho a seguinte situação:

Para cada registro tenho um COD, e um ano_inicio e ano Fim, preciso que crie pra cada COD, as linhas informando que ele permaneceu de ano_inicio até ano_fim.

Exemplo:

COD | ANO_INICIO | ANO_FIM

1       |  2002             | 2005

2       |  2006             | 2008

Resultado esperado:

COD | ANO_PERMANC

1       |  2002           

1       |  2003

1       |  2004

1       |  2005

2       |  2006

2       |  2007

2       |  2008

Consegui fazer quando no LOAD filtro apenas um COD, segue QVW.

I was trying to integrate Qlik with Llama ,I was using the default Meta(Amazon_Bedrock) anaytics connection in Qlik cloud.

The connection was created successfully and i used the below script for testing

QuestionsTable:

Load * Inline [

Question_ID,Question

1,"show me general ways to help boost a company's sales"
2,"what are the core concepts in accounting?"
3,"how large is the sun?"
];

[Meta]:
LOAD
[generation],
[prompt_token_count],
[generation_token_count],
[stop_reason],
[RowId]
EXTENSION endpoints.ScriptEval('{"RequestType":"endpoint", "endpoint":{"connectionname":"Meta_(Amazon_Bedrock)"}}', QuestionsTable{Question_ID,Question});

exit script


But i got an ERROR  

"  Connector reply error: grpc::StatusCode::FAILED_PRECONDITION: 'Error while converting required format. Status(StatusCode="FailedPrecondition", Detail="Error returned by endpoint: NotFound Could not resolve the foundation model from the provided model identifier.")'   " 

Any Solutions ??

Create global context variables in Talend, then call upon those variables from within a python script that talend runs. I can't figure out a way to get it to work. I have tried creating the context variables I need, adding them to a tSystem command, then my command to run the Python file looks like "python /path/pythonfile.py ${dbname} ${host} ${pw}"