Hi,

I am wondering when I have a source lookup on a column in a table, then I also have a filter on the table. What comes first? Are the records filtered then the source lookup occurs? or does the source lookup occur then the rows are filtered?

Regards,

Mo

Hi Team , 

We are replicating data from SQL Server to Postgresql

For SQL Server we are using MS-CDC for real time replication. But its Capture job is getting failed with error 

nested limit exceed 32.

Version for SQL server is 2017 standard edition.

Any solution or ideas is appreciated !!!

In March of 2024, Snowflake announced that Hybrid Tables are now in QA.

Will the Snowflake target endpoint connector be modified to support replicating data to Hybrid Tables as well as traditional Snowflake tables? Is this on the roadmap?

https://docs.snowflake.com/en/release-notes/2024/other/2024-03-05-hybrid-tables
https://docs.snowflake.com/en/release-notes/2024/other/2024-03-13-hybrid-tables

Hi,

This is my first partipation in the Forum. I need some help with my app.

I have a master measure to count dengue cases from December 2022 to April 2023. The problem is that to filter the months I use a variable that contains the aggregation with an analysis set that filters the months, and I call it as a function with the year as a parameter (to be able to apply it to 2023/24) but with this I end up taking the months of the year that passed as a parameter, that is, if it is 2023 it takes: January, February, March, April and December, instead of taking : December (2022), January, February, March and April, that is, December is also 2023. 

I tried to solve it by making a condition in my master measure so that when the month is December, I pass the previous year and the month of December as parameters, and if the month is any of the remaining months, I pass the current year and those months. I think it can work but when I spend several months as the 2nd parameter, it cuts off at the first comma it finds.

I give you a bit of the code of how I have proposed it. Notice for the abbreviations and names of variables, measures and dimensions are in Spanish

My master measure

if(Mes='Dic',${vCantCasos(2022,'Dic')},${vCantCasos(2023,${vSetMesesSinDi})})

The error

 

First simple solution but didnt work by the single quotes:

 

='Ene,Feb, Mar, Abr' (this would be a variable)

 

Second solution that almost work but I have the issue with the comma:

 

 

 Finally, I share this other alternative because I need for the set analysis for the month values ​​to be passed as strings with single quotes, but from the beginning it did not work (I also share the error it gives me).

 

 

I don't know how to move forward and I've already looked for the solution but I can't find anything that is useful to me. I hope that with what I shared you can understand everything and someone can give me a hand. From already thank you very much

 

 

 

For i=1 to 3

     if $(i)<2 then

          //jump to next

     end if;

     //code xxxxxxx

     //code yyyyyyyy

NEXT

Above is the requirement, if i=1, do nothing.

I know I can put the code xxxx/yyyyy into ELSE, any other workaround/solution?

How to do this? I tried NEXT, but I get runtime error.

Bom dia, pessoal

Preciso trazer, em uma tabela como dimensão de Competência (01/01/2024), valores dos últimos 12 meses baseado na competência da dimensão.

No gráfico abaixo, os números 2234 e 1334 são números da competência. Abaixo, está o número dos últimos 12 meses.

Existe alguma fórmula para ajustar isso?

Boa tarde, Estou tentando fazer uma comparação entre o período atual - período passado / período passado * 100, o objetivo é conseguir uma variação de vendas em %, por exemplo, em meu filtro estou comparando o mesmo período em anos diferentes Fevereiro de 2023 e Fevereiro de 2024

A EXPRESSÃO QUE ESTOU USANDO É: 

( ( Sum({<Ano_DC={"$(VAnoAtual_DC)"}, Mes_DC={"$(VMesAtual_DC)"}>} TOTAL_ITEM_DC) - Sum({<Ano_DC={" $(VAnoAnterior)"}, Mes_DC={"$(VMesAtual_DC)"}>} TOTAL_ITEM_DC) ) ) / Soma({<Ano_DC= {"$(VAnoAtual_DC)"}, Mes_DC={"$(VMesAtual_DC)"}> } TOTAL_ITEM_DC)

ENVIANDO AS VARIAVEIS
VAnoAtual_DC:
=MAX(Ano_DC)
VAnoAnterior:
=MAX(Ano_DC) -1
VMesAtual_DC:
=MAX(Mes_DC)
 

Hello,

Is there any way to chose the ledger format for a large report that I want to print directly from Qlik Sense? I want to avoid the action of loading the data in Excel. I noticed that when I want to have a PDF version, the document is like a photo, which mean, I cannot select the data...Is it because my administrator restricted me or Qlik Sense doesn't save any reports in PDF(not the printing version).

Thank you!

I can not get my QlikView desktop (edition info below) to lease a license from the server.  When trying to connect to the server I get this pop up error.  What am I doing wrong?

========================= QlikView Info ==========================
Client Version
Server Version
QlikTech Product QlikView 64-bit Edition (x64)
License Key [Personal Edition]
Production Date 2024-01-01
QV_BUILD_INFO release/QV12-80/55
PE Recoveries Remaining 1
CPU Target x64
======================= Local System Info ========================
Operating System Microsoft Windows 10 Pro (64 bit edition)
Operating System Version 10.0.19045
Wow64 mode Not using Wow64
IE Version 11.3636.19041.0
MDAC Version 6.3.9600.16384
MDAC Full Install Version 6.3.9600.16384
ComCtl32 version 6.16.10586
Current Theme C:\windows\resources\themes\Aero\Aero.msstyles
Graphics 1 1920*1080 pixels. 2 Monitors.
Graphics 2 32 Bit Color Depth. 96 XDpi. 96 YDpi.
Local Time 2024-05-09 15:46
GMT Time 2024-05-09 20:46
Country USA United States United States
Language 0409 English English
Physical RAM(MB) 16016
VMCommitted(MB) 88
VMAllocated(MB) 4983
VMFree(MB) 6378
VMLargestFreeBlock(MB) 6378
RecommendedFree(MB) 0
Number of CPUs 12
CPU 0 13th Gen Intel(R) Core(TM) i5-1345U 2496MHz
CPU 1 13th Gen Intel(R) Core(TM) i5-1345U 2496MHz
CPU 2 13th Gen Intel(R) Core(TM) i5-1345U 2496MHz
CPU 3 13th Gen Intel(R) Core(TM) i5-1345U 2496MHz
CPU 4 13th Gen Intel(R) Core(TM) i5-1345U 2496MHz
CPU 5 13th Gen Intel(R) Core(TM) i5-1345U 2496MHz
CPU 6 13th Gen Intel(R) Core(TM) i5-1345U 2496MHz
CPU 7 13th Gen Intel(R) Core(TM) i5-1345U 2496MHz
CPU 8 13th Gen Intel(R) Core(TM) i5-1345U 2496MHz
CPU 9 13th Gen Intel(R) Core(TM) i5-1345U 2496MHz
CPU 10 13th Gen Intel(R) Core(TM) i5-1345U 2496MHz
CPU 11 13th Gen Intel(R) Core(TM) i5-1345U 2496MHz