Welcome to Qlik Community

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!

In a combined chart: how to add a second measure to "height of bar". I am currently only able to add a second measure to  "height of line"   See attachment

Hello There,

how to use this kind of function in QlikView

IF(06/30/2020 > FieldDate, "yes" the also

IF field A- (MONTHS BETWEEN 06/30/2020 - FieldDate) == REM, "CURRENT"
ELSE "FUL"

Thanks

Bing

Hi All,

I have to create a pivot table like below. I have 8 expressions and 3 dimensions.  A sample  requirement is below.

I have created the NSC and TSC part , but I have to create a summary part as well. 

So in the summary for Programme A the YTD should TSC-A + NSC-A(100+200=300),

similarly for B it should be TSC-B + NSC-B.(500 + 100=600). 

Is this possible ? Please can any one help?

Regards

Ankhi

I am trying to implement Section Access on some fields. 

LOCAL table is sort of a super set table of DIVISION table with two additional values

Here are my requirements:

1. I need to grant ADMINS access to all the values in 3 fields.

2. All USERS should have access to MEDICAL and PUBLICITY in LOCAL by default

3. I need some USERS to have access to SALES and CORPORATE in DIVISION

4. I need some USERS to have access to SALES in DIVISION, ACCOUNTS in BRANCH

My Credentials are based on IDs. I tried some methods but 2nd condition keeps failing if I enable other conditions. How do I achieve this?

SECTION ACCESS;

ACCESS:
LOAD * INLINE
[ACCESS,ID,DIVISION,BRANCH,LOCAL

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