Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello!
I am a bit stucked so maybe you may help 🙂
I have a list of projects A, B, C, D.
Each project has assigned a program value : program X, Y, Z.
Each project has an EAC value.
I would like to create a list of Program/Projects that are greater than a thresold, let's say 400. This is used as a dimension (a dimension for the "bar" in a bar graph).
Example :
In that example, the code would return a list of values : program X (as 800 > 400) and project C (550 > 400).
My code below is working more or less, however, there is strange behaviors. I have missing values. If I treat that a bit differently, I have other conflict (for example, the list would return "project B" as well, as it is an individual value above 400. Which is not good as this project is already embedded in the "program X" value, also listed...)
Any idea how to treat that in a better way than my code below ?
thanks !
=
if(
(
// test if there is a program assigned or not
[Project Program]<>' <NoData>'
AND
// shows the program names when the total EAC of the program is greater than 400M
aggr(
(
sum({$<[Cost Baseline Version]={"RF*"}
,[Project Tiering]={"Tier 1","Tier 2","Tier 3"},[Monthly Cost Destination]={'CAPEX','OPEX'}
>} EAC/1000000)
)
>400
,[Project Program])
)
,[Project Program],
// else if the program is not above 400M, check and show if any individual project is above 400M
if(
(
[Project Program]=' <NoData>'
AND
aggr(sum({$<[Cost Baseline Version]={"RF*"},[Project Tiering]={"Tier 1","Tier 2","Tier 3"},[Monthly Cost Destination]={'CAPEX','OPEX'}
>} EAC/1000000)>400,[Project Description])
)
,[Project Description]
))
Hi all
I need to left join these 2 tables so that the columns from the budget table joins to the first one when event_code and weeks_left_to_event are the same. I came up with this code but doesn´t work.
Many thanks!!!
This is the code:
Hi!
Is it possible to override the Qlik Sense Cloud OData connector so that you e.g. can use a variable as input to the Auth header field?
Something similar to when working with the REST connector. I have tried to add the following code without success:
"WITH CONNECTION(
URL "$(vURL)",
HTTPHEADER "auth_type" "$(vheaderAuthType)",
HTTPHEADER "auth_token" "$(vTOKEN)"
)" ;
Hi Champions,
I am trying to sync my Azure AD users into my Qlik view Environment. I did some research on the subject on the community, but was not able to address my issue. Has anyone here successfully implemented this? Any pointers or guidance is appreciated.
Regards,
Rohan.
Getting below error while trying to do restoration
There are 37 other sessions using the database.database "QSR" is being accessed by other users.
Hi i need some help on how can i find APP name which is generating the QVD file
I am storing my qvd files in google drive
i am not using documentname() while generating qvd's
any automation read from google drive and get app name of the qvd?
Hello Experts,
I am configuring a new Qlik Alerting installation . As a part of that I installed Alerting in a separate server. And when I try to make connected to my QLik Sence i get following errors:
Not Connected, Socket Closed, Internal Server Error.
There is no blockage on firewall, all the ports are open. Not sure on what i need to check.
Could you please provide me some steps on how to debug this issue.
Many Thanks!
I exported the certificated and
HI,
I tried scheduling the tasks both with CDC and Store changes and fullload with applied changes. Once after running the tasks, it is not getting stopped . Is there a way to stop the task after each schedule execution completed?
Hi all,
I have three excel input - One is currentdata.xls, New.xls, old.xls. These are monthly data.
The input fields are the same, hence I have concatenated and added Flag to differentiate.
1. Load column1, column2, column 3, Month, 'Current' as Flag from currentdata.xls
2. Load column1, column2, column 3, Month, 'New' as Flag from New.xls
3. Load column1, column2, column 3, Month, 'old' as Flag from old.xls
Now I wanted to do calculation and store in QVD for future calculations.
For month = Jan, I need the below calculation,
a. if (Flag='Current', count(column1)) + if(Flag = 'New', count(column1)) as result1
b. result1 - if(Flag='old', count(column1) as result2
c. result2 for month Jan is my column1 for Feb.
d. This applies for each month.
When I do the calculation in front end or chart I am not able to store the result to input for the next month. So i would like to make the calculation in script and store the Month wise result in qvd to get for the next month. Can you please suggest a solution for the above. TIA
Wondering about Qlik Talend Data Integration Sessions? There are 11, in addition to all of the Data & Analytics. So meet us in Orlando, June 3 -5.
Browse our helpful how-to's to learn more about navigating Qlik Community and updating your profile.
Join us on April 24th at 10 AM ET for the next Do More with Qlik webinar focusing on Qlik’s Data Integration & Quality solutions.
Your journey awaits! Join us by Logging in and let the adventure begin.
Qlik enables a frictionless migration to AWS cloud by Empresas SB, a group of Chilean health and beauty retail companies employing 10,000 people with 600 points of sale.
Qlik Luminary Stephanie Robinson of JBS USA, the US arm of the global food company employing 70,000 in the US, and over 270,000 people worldwide.
Join one of our Location and Language groups. Find one that suits you today!
A private group is for healthcare organizations, partners, and Qlik healthcare staff to collaborate and share insights..
Qlik Communityの日本語のグループです。 Qlik製品に関する日本語資料のダウンロードや質問を日本語で投稿することができます。
Welcome to the group for Brazil users. .All discussions will be in Portuguese.
Hear from your Community team as they tell you about updates to the Qlik Community Platform and more!