Dear All,

 

I wish to compute the cumulative value for a measure.

In the below table I want to compute the cumulative value for the sales.

can you kindly advise , thanks for the help.

 

Product	Month	Work day	Sales	Cumulative (expected result)
A	Jan	1	3	3
A	Jan	2	4	7
A	Jan	3	5	12
A	Jan	4	6	18
B	Jan	1	4	4
B	Jan	2	2	6
B	Jan	3	3	9
B	Jan	4	4	13
A	Feb	1	2	2
A	Feb	2	3	5
A	Feb	3	7	12
A	Feb	4	9	21
B	Feb	1	11	11
B	Feb	2	13	23
B	Feb	3	14	37
B	Feb	4	15	52

 

Show Less

Hello Team,

Currently, I have a table as below and I need to put filter in the expression in Qlik Sense

Can you please help to write a filter expression to get the only one record which is not in Done status and having least date,

From my below table I wanted to get the Name as Record 2 as the status is not Done and the date is smallest of the records which are not in done status

ID	Name	Date	Status
1	Record 1	2019-10-08	WIP
2	Record 2	2019-09-18	ASSIGNED
3	Record 3	2019-08-15	DONE

Show Less

Hi,

I am trying to understand why set analysis drops some rows when chart dimension value is null and measure field exists in different than chart dimension field.

I have attached sample app, very similar to what we have in production app. The main question is, why left chart shows count 2 against null dimension but right one shows 1 against null dimension.

I observed if I replace set analysis expression with IF statement, both chart shows 2 against null dimension value.

 

@Henric_Cronström 

@swuehl 

@stevedark 

@rwunderlich 

@jagan 

@Gysbert_Wassenaar 

@sunny_talwar 

Any help will be highly appreciated.

Thanks,

DJ

 

 

Show Less

Precisava identificar as 10 primeiras iterações realizadas por determinado usuário.

Estamos efetuando esse processo em 3 passos

• Ordenação por usuário e data de iteração;
• Criação de um índice sequencial novamente por usuário e data de iteração;
• Leitura dos índices de 1 a 10.

Como a tabela contém mais de 100 milhões de registros, na hora de realizar a ordenação e o índice sequencial, a tabela fica por mais de 48 horas sem finalizar o processo.

Alguém sabe uma maneira de otimizar essa situação?

Segue um resumo do script realizado.

[Tabela 1]:
LOAD *
FROM e:/metricas.qvd(qvd);

//Ordenando e Criando índice
[Tabela 2]:
Load usu_codigo,
     data,

     acao,
     AutoNumber(RowNo(), usu_codigo) as indice_usuario
Resident [Tabela 1]
Order By usu_codigo, data;


//Selecionando as 10 primeiras interações
[Tabela 3]:
Load usu_codigo,
     data,

     acao,
     indice_usuario
Resident [Tabela 2]
Where indice_usuario <= 10;

Drop Table [Tabela 2];

Show Less

I have one Qlikview application in which i got request from client that certain data can only be available to certain users.

So i have used row level section access security.But i have one doubt regarding it.

If there are 100 users are using that application and i want 15 users to have access of certain data only.

so for applying security for 10-15 users, i have to create hidden script for it. So is it necessary to write the code about the access of all the 100 users in that script?like 85 users have admin access and other 15 users have specific area of access. 

Is there any other way where i can write about those 15 users only that can use certain data only? because in future there are possibilities to increase the count of users. So every time I need to change the code.

Show Less

Hi All,

 

I am new to QS and try to load two excel files. Each excel files contain three sheets. These excel files name 2018 and 2019. The sheets name for those excel files are 07, 08 and 09. I would like to create two Tables in QS but not sure why it will combine into one Table after loading below script. Can anyone help me to check? Thank you.

 

LET vStartSheetNumber2019 = 7;
LET vEndSheetNumber2019 = 9;
FOR index2019 = vStartSheetNumber2019 TO vEndSheetNumber2019

2019:
LOAD
*,
'2019' as [Year]
FROM [lib://Data/2019.xlsx]
(ooxml, embedded labels, table is [$(index2019)]);
Next

LET vStartSheetNumber2018 = 7;
LET vEndSheetNumber2018 = 9;
FOR index2018 = vStartSheetNumber2018 TO vEndSheetNumber2018

2018:
LOAD
*,
'2018' as [Year]
FROM [lib://Data/2018.xlsx]
(ooxml, embedded labels, table is [$(index2018)]);
Next

Show Less

Hi,

We have installed Qlik Sense Mobile on Apple Ipad.

As per the rules provided by Qlik, we have done changes in QMC (Offline access, Client Authentication Link, enabled TLS 1.2).

We are getting issue "Server login Attempt failed". Please help us to close this issue.

Thanks,

Kalyan

Show Less

Hi all, Please help me in preparation of best data model which i was mentioned in the attachment code table, Function, Region, Country table are same in left side table and right side tables please find my attachment and give suitable data model advise Thanks in Advance ... Show Less