Hi We have a requirement, to tokenize a specific column when the data is replicated from a source to target (In flight)

I have seen you can add "External API" custom code that you then can add the API call to Tokenize the data.

We will need to connect / get tokenized by a system called Voltage, but have no idea where to even start.

Hello.

I analyze sales on ebay auctions. I have an auction list and a sale on them (by days [SalesDate]). Each auction has a start and end date (AuctionEndDate). I want to count auctions completed in a month that had sales in the last 7 days before the end.

I want to get a simple table with two columns:

1. month([AuctionEndDate]) and it is ok
2. count of auctions with sales in last 7 days

I tried with 

count(DISTINCT {<[AuctionID] = {"=Sum({<[SalesDate]={">$(=date([AuctionEndDate]-7))"}>}[Sales])>'0' "}>} [AuctionID])

... but without success.

Please help 🙂

Thanks,

M

Hi all,

I am generating some numbers and showing in text objects based on certain conditions. There are multiple text objects on the sheet and each has a different condition. I have two separate categories for the text objects and want to be able to apply date filters to these two categories separately, e.g. 2020 to one category and 2021 to the other category. I have created two separate Date fields as well to use as listbox but when i am selecting one date filter, the other one deselects. Tried Alternate State but it does not show any count in the respective text object when applied to one listbox and in the text object expression.  please help share some idea as to how to solve this.

I am using the below expression for Alternate State named as "TESTING":

=num(Count({TESTING} distinct {$<[As of Date]={'$(vCurrMonth)'},[In Progress]={'1'},[Testing Type]={'1'},}testno),'#,##0')

Bom dia!

gostaria de compartilhar um problema que tive, para que fiquem atentos e tomem medidas preventivas caso aconteça com vocês!

Estou trabalhando em um cliente que utiliza o Qlik Cloud (versão SaaS do QlikSense). Ontem no final da tarde, após uma atualização dos dados, percebi que vários objetos estavam sem valores, e quando fui investigar, as variáveis que guardavam as fórmulas estavam com a definição completamente diferente do original! SIM! A definição da variável foi mudada completamente! 

Para minha sorte, eu utilizo o KPI Repository do Christof Schwarz, então as variáveis que foram definidas no script não sofreram alteração, porém, as que foram criadas diretamente no editor estavam totalmente diferentes do original.

E para a minha sorte [2] eu tinha um backup do aplicativo do dia 17 na minha máquina.

Olhem um exemplo, são as mesmas variáveis. Na primeira imagem é o meu backup do dia 17 (no Sense Desktop), e na segunda imagem é o aplicativo no QlikCloud:

desktopSaaS

Portanto amigos, fica de lição aprendida... backup diário das aplicações quando estiverem trabalhando com SaaS! Se não fosse o KPI repository e o meu backup, poderia ter SEMANAS de trabalho completamente perdido!

Hello Everybody

I am still a beginner when it comes to QlikSense. In the app I'm trying to create, I want to load all data older than 2 weeks than the newest time of DATE_STARTED.

What I have tried until now without success.

LOAD

Timestamp([DATE_STARTED] , 'D/M/YYYY') AS [DATE_STARTED]

....

Where DATE_STARTED >= (today()-14);

What I'm missing, or is this approach efficient ?

Thanks for your time and help 

hello I want to install the qlik sense desktop free  in my pc but I cannot see the link in webpage.

I could only find to install  the qlikview  but not the  sense 

could you please help me where can I find the link for the download of qlik sense desktop?

thanks

I have a LOAD script like:

Concatenate(Sales)

SELECT

aa,

bb

FROM $(vMyPath)file1.xlsx (ooxml, embedded labels, table is INPUT)

;

Concatenate(Sales)

SELECT

aa,

bb

FROM $(vMyPath)file2.xlsx (ooxml, embedded labels, table is INPUT)

;

I.e. 2 blocks of code where only the names of the excel source files differ. (How) Can I reuse the main part of the code to shorten the script and do something like:

Sub MySub(MyExcelFile)

    Concatenate(Sales)

    SELECT

    aa,

    bb

    FROM $(vMyPath)MyExcelFile (ooxml, embedded labels, table is INPUT)

    ;

end sub

call MySub(file1.xlsx)

call MySub(file2.xlsx)