Welcome to Qlik Community

Hi,

Wondering if anyone can help me with a set analysis issue. The below expression works if I make the week number = to 38 (our current week for reporting) or equal to a variable that also equals 38, however if I were to change the value to any other number the cell goes to null, despite their being a value for all 52 weeks. Curiously despite me using set analysis the expression is also influenced by selecting the week filter, so if choosing anything other than the current week (38) the cell will return a null value. Hopefully I've explained this issue well enough.

Expression:

Sum(Aggr(Sum ({$<Week={37},Year={$(vLFLCurrYr)},Date=,[Retailer Status]={'OPEN'},
IT_System_Week= > } DISTINCT [Budget Nett Sales]),[Week],[Retailer Code],[HRL Finance Group]))

A recent update to Insight Advisor is that there is a new “Discovery” button that generates insights without you having to navigate away from the current sheet. It is no longer a landing view with its own navigation point in the top toolbar. Its new location will improve your consumption of data within the sheet! And "Ask Insight Advisor" search box is always visible within dashboards, allowing you to easily generate insights using natural language processing.

Tell us how you like the new navigation below!

Visit this QlikWorld 2021 breakout session led by @Steven_Pressland  for a deeper dive on how to make the most out of the capabilities using Insight Advisor.

Bom dia a todos. 

Tenho uma tabela que mostra o Código de um chamado e todos os status que este chamado passou. 

Eu precisava gerar uma coluna na tabela onde ele calculasse o tempo em que o chamado ficou em cada status (acredito que teria que usar a função ABOVE para realizar esta tarefa. Mas não entendi como ela pode ser usada.

Depois que eu calcular esses tempos totais de cada chamado eu preciso exibir a soma de todos os tempos subtraindo o tempo em que o chamado ficou com o Status 'AGUARDANTO TERCEIROS' 

Não sei se no próprio ABOVE eu posso gerar um IF para que quando a coluna de status for Aguardando terceiros ele coloque o tempo a seguir como ZERO.

Hello Qlik Enthusiasts , 

I want to have a little calendar where i can choose a particular date for example, 02-04-2022 and then get all the records which would be expired until this date. The date is as follows . 

Student , Document, Expiration Date, Document Status 

101, Doc1, 12-03-2021, Expired 

102, Doc2 , 12-09-2022, Valid

103, Doc3, 12-11-2021, Valid 

104, Doc4, 31-12-2021, Valid

for now i am calculating status if the expiry date is less than today then its expired. But i want to have a calendar where i can choose a particular date and get all the expired certifcates until that particular date. For example,if i select 31-12-2021 then i would like to get the following output . 

Student , Document, Expiration Date, Document Status 

101, Doc1, 12-03-2021, Expired 

102, Doc2 , 12-09-2022, Valid

103, Doc3, 12-11-2021, Expired

104, Doc4, 31-12-2021, Expired

Please help me solve this , Thank you for your valuable time in Advance. 

Hey everyone,

I am working on a Pivot table which has to be built based on an already created table chart. 

The table looks something like this:

I do not want all the account types in the pivot. I am trying to get only account types 'L','M', and 'O' into the Pivot and calculate the % of total by diving the amount with the sum of all amount for that particular account number, and displaying only the topmost value for that account number, which would look something like this:

This would have been a very simple  SQL query had I been working on that, but I am new to Qlik and this seems more complicated.

I read a couple of responses in other forums which suggest creating a variable but I am not sure how would that help me because I am kind of like grouping it by the account number. 

Any help or suggestions is highly appreciated.

Thank you!

=Sum({<OrderDate={">=$(=yearstart(addyears(max(OrderDate)),-1)<=$(=addyears(max(OrderDate)),-1))}>"}Sales)

this expression showing error[error in set modifier expression]

how to resolve it

Good morning,
i noticed that when i generate the reports with the button on my qlik sense app, it is displayed with all the others generated previously. Is there a possibility to delete them after they have passed a period of time?

Example: Type that reports generated before yesterday are cleared.

And is it possible to automatically block the reports that have been generated for a long time?

Example: Type if a report takes more than 10 minutes to generate it crashes.

I hope I was as clear as possible!