Hi.

I have below expression that sits in a pivot table under dimensions.

Aggr(Round(Sum({<[Pdiv Id No]-={6,11,12}, [SK Plan Type No]={1}, [Season Description EP]={'Winter'}>}[Binc Sale Sell Amt])), Division, Department).

This is returning the number format of 123456789.

I would like the above expresion to return 123 456 789.

How am I able to achieve that?

Hi All,

PFB script.

Can you please suggest how to simplify if statement from the script.

if(ApplyMap('AcquisitionMonth',ASSET_STATIC_ID,null())=Month, ApplyMap('AcquisitionMonth',ASSET_STATIC_ID,null()),null()) as ASSET_ACQUISITION_MONTH,
if(ApplyMap('AcquisitionQuarter',ASSET_STATIC_ID,null())=Quarter, ApplyMap('AcquisitionQuarter',ASSET_STATIC_ID,null()),null()) as ASSET_ACQUISITION_QUARTER,

if( len(Month)>2 and [Object Type Code]='A',(
ApplyMap('DispositionMonth',[%KEY_ASSET_SCD],'-')),
if(len(Quarter)>2 and [Object Type Code]='A',(
ApplyMap('DispositionQuarter',[%KEY_ASSET_SCD],'-')))) as PropertySold_Diversification,


if(len(Month)>2 and [Object Type Code]='A',(
ApplyMap('DispositionMonth_asset',[%KEY_ASSET_SCD],'-')),
if(len(Quarter)>2 and [Object Type Code]='A',(
ApplyMap('DispositionQuarter_asset',[%KEY_ASSET_SCD],'-')))) as PropertySold_Asset_download,


if( len(Quarter)>2,(
if(((Applymap('On_Off_Rules_Start_Qtr_MVRF',VEHICLE_STATIC_ID,'')<= Replace(Quarter,'Q','')) and
(Replace(Quarter,'Q','')<= Applymap('On_Off_Rules_End_Qtr_MVRF',VEHICLE_STATIC_ID))),'PL_OFF','0')
),
if( len(Month)>2,(
if(((Applymap('On_Off_Rules_Start_Mth_MVRF',VEHICLE_STATIC_ID,'')<= (num#(Month))) and
((num#(Month))<= Applymap('On_Off_Rules_End_Mth_MVRF',VEHICLE_STATIC_ID))),'PL_OFF','0')))) as PL_OFF,


if( len(Quarter)>2,(
if((((Applymap('On_Off_Rules_Start_Qtr_NAV',VEHICLE_STATIC_ID,'')<= Replace(Quarter,'Q','')) and
(Replace(Quarter,'Q','')<= Applymap('On_Off_Rules_End_Qtr_NAV',VEHICLE_STATIC_ID)))) ,'IL_OFF','0')
),
if( len(Month)>2,(
if((((Applymap('On_Off_Rules_Start_Mth_NAV',VEHICLE_STATIC_ID,'')<= (num#(Month))) and
((num#(Month))<= Applymap('On_Off_Rules_End_Mth_NAV',VEHICLE_STATIC_ID)))),'IL_OFF','0')))) as IL_OFF,


Thanks

Hello everyone,

I can't seem to do partial reload correctly in script

When i do 

if IsPartialReload() then
TRACE "PARTIAL LOAD";

TABLE_1:

Load *

From Table 1;

ELSE 

TABLE_2:

Load *

From Table 2;

TABLE_3:

Load *

From Table 3;

ENDIF;

What i don't understand is when i do partial reload using a button or CTRL + SHIFT + R i always get

Anyone can tell me what i did wrong ? No lines is loading during my partial load.

Thanks

Bonjour à tous,

Je débute avec Qlik Sense depuis qq semaines et j'aurai besoin de votre aide.

J'ai un fichier (dont le mais est de lister les dossiers en cours non traité) comprennant une colonne "Days" (avec des nombres entiers) et je cherche à créer 4 catégories pour définir des KPI sur le nombre de jours depuis lequel ils sont ouverts/non-traités :
- <2 (KPI 1)
- entre 3 et 5 (KPI 2)
- entre 6 et 10 (KPI 3)
- >10 (KPI 4)

Pour le moment, j'ai créé le script avec ça :
" [Days],
if ([Days]<3, '[:0-2 days]', if ([Days]<6, '[:3-5 jours]', if ([Days]<11, '[:6-10 days]', if ([Days]>10, '[>10 days]')))) comme Days_WF "

Pour la création de mes graphiques, je m'en sorte très bien jusqu'à-là (même si le script est surement peu académique), mais arriver à fixer des valeurs de KPI différents selon chaque KPI c'est là que je suis perdue .

J'ai bien compris que la représentation 'indicateur' ne pouvait pas combiner plusieurs dimensions, mais si mes KPI sont bien définis, je pourrai à minima utiliser un graphique pour chaque avec la représentation 'indicateur'

Merci d'avance pour votre aide ! 🙂

Hello everyone!

I have a problem with my date fields in my app. 

this is the structure of my app, basically I have a date range in table "Budget" from "datainizio" to "datafine".

I have to display in my app a table which shows a value from table "Globale" and a value from table "Budget" in the same period but I don't know ho to link the date fields in "Budget" table to my Master Calendar.
If I use month(datainizio) I can see "budget"field (from table Budget) in each month but I don't see "molt"field (from table Globale). If I use month(data01) (which is "Mese" in my master calendar) I can see "molt"field in each month but I don't see "budget"field.

I don't know if I am clear with my deal, could anyone help me?

This is my script:

//** GLOBALE TABLE

Globale:
LOAD
idMarca &'_'& [pv] as [% Key marca_pv],
scontrino,
idMarca,
azienda,
nomeazienda,
tipodoc,
destipodoc,
numerodocumento,
data01,
[pv],
puntovendita,
codmailing,
ragsoc,
tipologiaCliente,
agente,
tipoAgente,
desagente,
segno,
molt,
clifor,
preventivo,
ordinefornitore,
tipostat,
idarticolo,
descrizione,
codesterno,
marca,
gruppo,
linea,
reparto,
codreparto,
famiglia,
codfamiglia,
idmagprovenienza,
idmagazzino,
magprovenienza,
magazzino,
qta,
prezzo,
sconto1,
sconto2,
sconto3,
importo,
costo,
provvigioni,
costoAnagrafico,
prezzolistino1,
prezzolistino2,
prezzolistino3,
prezzolistino4,
prezzolistino5,
prezzolistino6
FROM [lib://letturadati/Globale.qvd]
(qvd);

//** BUDGET TABLE

Budget:
LOAD
Budget.idMarca &'_'& Budget.pv as [% Key marca_pv],
Budget.idMarca,
ID,
Budget.tipo,
Budget.tipostat,
Budget.descrizione,
datainizio,
datafine,
Budget.pv,
idAgente,
Budget.codmailing,
budget,
peso,
budget*peso as budgetcalc
FROM [lib://letturadati/BudgetMarca.qvd]
(qvd);

//** CALENDAR

QuartersMap:
MAPPING LOAD
rowno() as Mese,
'T' & Ceil (rowno()/3) as Trimestre
AUTOGENERATE (12);

Temp:
Load
'01/01/2021' as minDate,
max(data01) as maxDate
Resident Globale;

Let varMinDate = Num(Peek('minDate', 0, 'Temp'));
Let varMaxDate = Num(Peek('maxDate', 0, 'Temp'));
DROP Table Temp;

TempCalendar:
LOAD
$(varMinDate) + Iterno()-1 As Num,
Date($(varMinDate) + IterNo() - 1) as TempDate
AutoGenerate 1 While $(varMinDate) + IterNo() -1 <= $(varMaxDate);

MasterCalendar:
Load
TempDate AS data01,
week(TempDate) As Settimana,
Year(TempDate) As Anno,
Month(TempDate) As Mese,
Day(TempDate) As Giorno,
YeartoDate(TempDate)*-1 as CurYTDFlag,
YeartoDate(TempDate,-1)*-1 as LastYTDFlag,
inyear(TempDate, Monthstart($(varMaxDate)),-1) as RC12,
date(monthstart(TempDate), 'MMM-YYYY') as MeseAnno,
ApplyMap('QuartersMap', month(TempDate), Null()) as Trimestre,
Week(weekstart(TempDate)) & '-' & WeekYear(TempDate) as WeekYear,
WeekDay(TempDate) as WeekDay
Resident TempCalendar
Order By TempDate ASC;
Drop Table TempCalendar;

Thank to all!

Hi, 

how to find the ticket number for my post that I can give to the Support Team call?? People from call have required me to give. But I couldn't find the number.
When I tried to give the number in the url like 1812105 in https://community.qlik.com/t5/Deployment-Management/Slow-Performance-to-open-sheets-and-calculate/td-p/1812105 . People say this is not my ticket. I am really confused.

regards

Kefang

Hi All,

Requirement: I have two tables, let's call them Table A and Table B. For this requirement I'll be referring only two columns from both tables i.e. Number and ID. I need to look for Numbers from Table A in the Table B and check if the ID(s) associated with the Number in Table B are not different in Table A.  Please keep in mind that there can be duplicates as well as multiple IDs associated with the same Number.

Let's look at the below scenario for better understanding.

Table A:

Number           ID

123                      1

124                      2

124                      3

125                      4

125                      4

125                      5

126                      6

127                      8

Table B:

Number             ID

123                       1

124                       2

124                       4

125                       5     

126                       7     

127                       8

127                       9

From this scenario - Numbers 124,126 and 127 falls under the issue category that I need to show the users.

In Table B there's an ID 4 which is related to Number 124 but not in Table A and 126 is straightforward as IDs don't match in both tables for this Number. For the Number 127, there's only one record in Table A but two in Table B and ID 9 is not present in Table A for the same Number.

123 is a straight match with  ID 1 and 125 has only onw record in Table B compared to 3 records in Table A albeit one being a duplicate but ID 4 is present in the Table A as well so this one is fine.

I hope i have made the requirement clear, if not then please let me know. Any suggestion or help will be appreciated.

Thanks!                          

Olá, sou nova no Qlik e não sei se há como fazer o que preciso.

Abaixo detalharei.

Tenho um contêiner, que contém outros objetos(Gráficos dinâmicos), minha pergunta/dúvida é, há como através de um campo Lista, ou botão ter uma opção que eu pudesse selecionar o Gráfico dinâmico 2(por exemplo) sem precisar ir na caixa de seleção do contêiner? ( no desenvolvimento de software eu saberia como resolver fácil a questão).

Dessa forma ficaria mais dinâmico para o usuário poder selecionar o que gostaria de visualizar, sem que eu precise mexer nas estrutura de como está hoje esses gráficos(sem inclusões de if's nas expressões)

I am performing scalability testing for QlikView. 

After end of run, log fetcher is not opening. i tried it from "Tools" menu. That option is also not working.

Please help here with solution.

We have upgraded  Qlik sense from April 2018, Patch 1 to Feb 2021, Patch 7. 

After the upgrade, I have some apps that fail to load from QMC Task, but are fine when I load data using Data Load Editor. The tasks in the red box are those that ran after the upgrade. The 3 selected ones keep failing. I have tried to reload the data using data load editor, then republish the app, and try to rerun the reload from task, but they still fail.

Could you check what could be the issue? Not sure if this will happen for the other apps whose reload tasks are not executed yet...

Attached are the log file and screenshot for your reference.