Welcome to Qlik Community

Alguém saberia me dizer por que a regra a segue retorna nulo na tabela? Quando eu faço uma seleção de apenas 1 dia pela data a regra funciona devidamente, mas fica cheia de valores nulos quando está sem seleção.

AVG({<len_c_itemred = {'7'}>} [Estoque])

/

(
SUM(
Aggr( SUM({<len_c_itemred = {'7'}>} [Estoque]) * Avg({<len_c_itemred = {'7'}, [Estoque]=-null>} padrao_producao), [Cód.Produto]) )

/

SUM( Aggr( SUM({<len_c_itemred = {'7'}>} [Estoque]), [Cód.Produto]) )

) 

While it's hard to believe we are in August already, it does mean a new month and another opportunity for our monthly "Round of Applause". This month goes to our very own Qlik employee Brett Bleess! Brett is part of our Digital Support team,  has over 3500 posts, and countless interactions in the community. Brett is a valued partner to our team and we appreciate all of his interactions and moderation he provides.  

Brett started with Qlik in Oct 2004 and has been a part of the support organization the entire time due to his overwhelming drive to solve problems.  When he started, we were on version 6 of the QlikView product and that was the only product we had! His community presence is part of his job, however, he really enjoys spending time in the community as things tend to be a bit more laid back and collaborative than in the case environment.  Also, much of the time things are not as urgent and people tend to be much more appreciative of the help/guidance they receive. While he mainly collaborates in the QlikView product area,  when time allows, he is able to get into the Qlik Sense forum.

In his spare time, Brett enjoys doing projects around his house as well as for friends and family. He has a dedicated woodworking shop in his backyard with a full suite of tools. He really enjoys building new things and fixing old. Brett grew up on a farm and really misses working on tractors. He wants to buy a subcompact tractor, so he can do projects using the tractor.  Due to the virus tractors are in short supply, however, he is hopeful to buy one soon. 

Let's give Brett a round of applause by adding a comment and/or giving him a like! @Brett_Bleess @Courtney_Cromley @Wlad_Masi @Melissa_Potvin 

Hi guys,

We sent some testing emails to external users via NP19. Is that possible to request read receipt in NP19 so we can easily know if message opened? Or, at least if there are any logs we can check message delivered?

Thanks for your help.

Fion

Hello together,

I want to do a measure pointer with segments and different colors, where I can see :

- sale of last year  per day

-plansale per day

actual sale per day

It should be dynamic, in depency of a date.

Does anybody have a idea?

best regards

wuensche

Hi there, 

I have a restricted sharepoint list that I need to set connections to QLIKsense. 
Due to restrictions to the Sharepoint list, QLIK is unable to stablish a connection. 

Could anyone suggest best way forward?
My guess is that I need to add QLIK to the sharepoint access users?
I have not got a clue! 

Thanks a million for your support on this!

Regards

Jose 

I have a table with visit summary of patients visiting the hospital. This table contains the VisitID, PatientID, DateAdmitted, DateDischarged. I need to identify visits which were readmissions (i.e. visits which happened within a gap of 30 days from the previous visit). I need to add two columns flagging the visit as a readmission using the DateAdmitted and DateDischarged as Readmit_flag (a visit from a patient who was admitted in the hospital less than 30 days ago) and PrevAdmit_flag (an admission which lead to a readmission).

Dummy Data:

Output:

PA1, PA2, PA3 got readmitted within 30 days of their previous discharge, so their readmit_flag is 1 and the corresponding previous visit is flagged with PrevAdmit_flag as 1. PA4 was admitted after more than 30 days so flag is 0 for both readmit and prevadmit.

Please help me achieve this on the Load Editor. Thank you. 

Hi Everyone,

Is it possible to do in qliksense.Below is the requiement.

L= Low

M=Medium

H= High

VH= Very high

Is it possible in qliksense

Hello,

I am a beginner in Qlik Sense. Since I am working on a huge dataset, I am aggregating the values before importing it in Qlik Sense to improve the  performance. Now, I wish to only display a pre-aggregated field in a KPI chart. Below are the options that I get while adding a new measure to the KPI chart.

If I forcefully edit the expression to remove the aggregation, it does not display any value.

My aggregated table now looks like this:

So I plan to have a Filter panes for Year and Gender and KPI chart or Patient Count. 

Can anybody kindly suggest a work around?

Any help will be greatly appreciated! Thanks!