Everything you need to make your Qlik Community experience valuable.
Explore official Support and member created content.
Welcome Emmy award-winning Katie Linendoll as our emcee and world record-holding cave diver John Volanthen as our keynote speakers.
Forums for Qlik Data Integration solutions. Ask questions, join discussions, find solutions, and access documentation and resources
Share your best Qlik apps and discuss impacts with peers! Show your work and get recognized for innovative uses of Qlik technologies.
Get started on Qlik Community, find How-To documents, and join general non-product related discussions.
Direct links to other resources within the Qlik ecosystem. We suggest you bookmark this page.
Qlik gives qualified university students, educators, and researchers free Qlik software and resources to prepare students for the data-driven workplace.
Hi Experts,
I'm doing cumulative sum - that is working fine, but if user select any product cumulative value should not be change.
below is my cumulative sum and I'm selecting one product as Tab, here cumulative sum has changed to 10.
Cumulative Sum: RangeSum(Above(TOTAL Sum(Sales), 0, RowNo(TOTAL)))
I did some work around when user select product, finding MIN and MAX value
like Min(Sales) and max({<Product=>}Sales)) - same way applied in set expression
=Sum({<Sales ={">=$(=min(Sales)) <=$(=max({<Product=>}Sales))"}, Product=>}total Sales) - this expression is working fine for one product selection.
but my problem is when user select multiple products not working.
my output should be:
if user select single product or Multiple products should not be change the cumulative value (If any sub filter selections cumulative should not change)
Thanks in Advance!
I have a field 'Lot '
in field 'Lot ' contains data :
I want to put 'A0' as the first two in this field.
example :
A0165052171
A0172050012
.
.
.
I have a field 'Lot '
in field 'Lot ' contains data :
want to add '-' to count the 6th data from the left.
EX
165052171
A0172050012
I created two space to offer an autoevaluation solution to a company:
- One space with a data entry saving Qvd within the space.
- One limited acces space for manager where a BI tool give them the opportunity to make data analysis.
I would like to automate two things:
1) when the qvd is stored (partial reload), i would like it to be moved automatically to the second space to be sure these data are made private.
2) Reload the BI tool to add load the new entries.
I can't figure how to move these qvd from one space to another with automation. Does anyone has completed such a task ?
Thanks in advance.
Date | Category | Total | Date total |
1/1/23 | A | 5 | 35 |
1/1/23 | B | 10 | 35 |
1/1/23 | C | 5 | 35 |
1/1/23 | D | 10 | 35 |
1/1/23 | E | 5 | 35 |
1/2/23 | A | 5 | 10 |
1/2/23 | A | 5 | 10 |
How can make a table like this? The total is based on date + category but the date total is based only the date
Hi there,
I try to use the Intersect operation from the Geo Connector on QLik Saas.
I create two area from a point and want to calculate the intersect ratio. Same script have been used to create each table:
Ikea_And:
Ikea_And_ID, $Key
Ikea_And_TravelArea $Geopolygon, $relates_Ikea_And_ID $ ascii $text
Ikea_Zav:
Ikea_Zav_ID, $Key
Ikea_Zav_TravelArea $Geopolygon, $relates_Ikea_And_ID $ ascii $text
I use the connector to configure the intersect and got this script:
[IntersectsResultTable]:
Load * Extension GeoOperations.ScriptEval('
SELECT dataset_dataset2_RelationId, Ikea_Zav_ID, Ikea_And_ID, dataset.RelativeOverlap, dataset2.RelativeOverlap, dataset2.Ikea_And_TravelArea, dataset.Ikea_Zav_TravelArea FROM
Intersects(intersectsCount=0)
DATASOURCE dataset INTABLE keyField="Ikea_Zav_ID", crs="auto", polygonField="Ikea_Zav_TravelArea"
DATASOURCE dataset2 INTABLE keyField="Ikea_And_ID", crs="auto", polygonField="Ikea_And_TravelArea"
', Ikea_Zav);
When i load the script, I get this error:
Any clue ?
I am using Qlik Sense EoW Aug 2022 Patch 3. I am getting unusual results when using an Outer Set Expression.
I am applying an Outer Set Expression to a master measure [Filled Positions]. When the value I use for the "Candidate Source" field does NOT exist anywhere in the data set for the app the expression for that field is ignored.
So this measure:
({<[Snapshot Year]={">=$(vPreviousYear_1)"},[Snapshot Month/Year]={"<=$(=Max([Snapshot Month/Year]))"},[Candidate Source]={'_UNKNOWN_'}>}[Filled Positions])
Returns the same value as this measure when "_UNKNOWN_" is NOT present in the data, but works correctly when "_UNKNOWN_" IS present in the data:
({<[Snapshot Year]={">=$(vPreviousYear_1)"},[Snapshot Month/Year]={"<=$(=Max([Snapshot Month/Year]))"}>}[Filled Positions])
If I create a new measure by copying my master measure [Filled Positions] and add the previous Outer Set Expression as an addition to the existing Inner Set Expression the result is correct, regardless of the presence of the "_UNKNOWN_" value in the data set.
Count(distinct{<[Table]={'Days to Fill'},[Max Emp Offer Date Flag]={'Y'},[Snapshot Year]={">=$(vPreviousYear_1)"},[Snapshot Month/Year]={"<=$(=Max([Snapshot Month/Year]))"},[Candidate Source]={'_UNKNOWN_'}>}[Job Req ID])
Is this a bug with my version? I did not read anything in the Qlik Help site related to Outer Set Expressions saying that a field would be ignored if the value was not part of the data set. Because I use Outer Set Expressions often now, it is very disturbing to think that they will work correctly most of the time, but if a value is dropped from the data set entirely, a previously working measure can return erroneous results.
Thanks
Hi Community,
I'm working on a tricky scenario.
Here it is.
I've below numbers:
LOAD * INLINE [
Number
62517
34
2174
];
Desired Output Required:
Number
12567
34
1247
If anyone has faced such issue then please share your suggestions.
Regards,
Eric
Hi! I am trying to create filtered views in a table, but can't figure out how to hide rows with measure having 0 or null value. I've tried disabling "Include 0 values" from data handling, and setting the output of this expression to display NUM values, but still not working. Expression below is calculating if date in Log for a record is within last day days.
=IF((today(2)-daystart(max({<[Session Count] = {1}>} LogTimeStamp)))<90,NUM(today(2)-daystart(max({<[Session Count] = {1}>} LogTimeStamp))),NUM(0))
I Installed data movement on linux that Redhat8 of AWS EC2.
I’m trying connect to Oracle database with data integration. but when push test connect button then get about proxy error.
Checking the data movement log file,there is about proxy error following
[ERROR] Error connecting to Replicate server 'local_repsrv'
System.Net.WebException: The proxy tunnel request to proxy 'My proxy adress' failed with status code '307'."
Do you have any good solutions in regards to that?
best regard.
Hear from your Community team as they tell you about updates to the Qlik Community Platform and more!
If you want to know what's new across all of the products in our growing Qlik product portfolio.
Get the latest Support information about end-of-product support, new service releases, and general support topics.
Read all about Qlik solutions: scripting, data modeling, visual design, extensions, best practices and more.
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.
10+ hours of roll up your sleeves, immersive working sessions. A $1000 value included in your conference pass!
Subscribe to our Events and Webinar page so you do not miss an event
opportunity!
Join the "Welcome to Qlik" webinar and learn about the Qlik Ecosystem, such as Qlik Community, Learning, and Help.
There is more than one way to find upcoming events, look on the right side
of any Qlik Community forum!
Subscribe to our Events and Webinar page so you do not miss an event
opportunity!
Join the "Welcome to Qlik" webinar and learn about the Qlik Ecosystem, such as Qlik Community, Learning, and Help.
There is more than one way to find upcoming events, look on the right side
of any Qlik Community forum!