Hi all, 

I have 2 fileds: AccountID and Scope. Some Account does not have a Scope (null in scope) and I would like to find them. I can work only in Front End, so no load script can be used.

E.g.:

I managed to create a KPI that show how many Account with null scope I have, with the formula

count({1}distinct AccountID) - count({1<[Scope]-={"-"}>} distinct AccountID)

(note that the formula "count({1<[Scope]={"-"}>} distinct AccountID)" gives a wrong answer: always 0.

Now I would like to see WHAT are those AccountID.

I tried a table with the dimension column "AccountID" and the measure column "Count({<Scope-={"*"}>} AccountID)", but it doesn't work

Neither does the measure column "Only({<Scope={"-"}>}  AccountID)" (it gives only one one full-null row)

Neither "IF(Count({<Scope={"*"}>} AccountID))=0, AccountID)" (it gives only one one full-null row)

Thank you for your help

Hi 

I am trying to trigger to Qlik Sense task from c# .net code. Is there any sample code or any useful links which can help me get started?

Many thanks

Hello,

I have a dimension called ''Exercice période'' in French which mean Period exercice. I want to systematically select the previous month of the period, as an example, we're in May, I want to select April.

Any expression for that please?

Thank you so much

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)
 

Hi , 

I was trying get a preview of an image in NPR designer, it runs for along time and fails with in error, while I preview the same with a table, output loads instantly. Could you help us in this regards

Is it possible to do an interval match with two set of intervals? In my fact data, I have the field month end, which looks in the interval Effective Start and Effective Stop. In that same interval match function, can I have the Sales field from my fact data, look in the interval Min Threshold and Max Threshold as well? This is ultimately so I can find out what scale to give my fact data, based on if the sales is between a certain amount and if the sales took place between a certain date range.

Here is what my two tables look like.

Fact Data:

Dimension/Intervals Data:

Hi community,

I was wondering if there is a way to disable the unlink option of the Master Visualization's. I would like that users can't do this in a published app.

Is it possible?

Thanks in advance.

Dear colleagues

we use Qlik sense enterprise on windows 2023May currently. 

If we want to upgrade to February 2024 what is correct steps and is there a manual I can follow.

whether we need backup before upgrade.

we also hope to be sure license also can be used after upgrade.

it is better can get your support ASAP.

😊

jens.