Skip to main content

Welcome to Qlik Community

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 187,941 members
  • 6,044 online
  • 1,741,355 posts
  • 133,529 Solutions
Announcements
Action-Packed Learning Awaits! QlikWorld 2023. April 17 - 20 in Las Vegas: REGISTER NOW

Welcome to Qlik Community

FOR NEW MEMBERS

Everything you need to make your Qlik Community experience valuable.

SEARCH KNOWLEDGE BASE

Explore official Support and member created content.

QLIKWORLD 2023!

Welcome Emmy award-winning Katie Linendoll as our emcee and world record-holding cave diver John Volanthen as our keynote speakers.

Analytics

Forums for Qlik Analytic solutions. Ask questions, join discussions, find solutions, and access documentation and resources.

Data Integration

Forums for Qlik Data Integration solutions. Ask questions, join discussions, find solutions, and access documentation and resources

Qlik Gallery

Share your best Qlik apps and discuss impacts with peers! Show your work and get recognized for innovative uses of Qlik technologies.

Ideation

Participate in Qlik Technical Previews, submit ideas, and review documentation.

Support

Chat with us, search Knowledge, open a Case, read the latest Updates Blog, find Release Notes, and learn about our Programs.

Events

Learn about upcoming Qlik related events, webinars and local meetups.

Groups

Join a Group that is right for you and get more out of your collaborations. Some groups are closed. Closed Groups require approval to view and participate.

About Qlik Community

Get started on Qlik Community, find How-To documents, and join general non-product related discussions.

Blogs

Hear directly from Qlik employees in our ten unique blogs.

Qlik Resources

Direct links to other resources within the Qlik ecosystem. We suggest you bookmark this page.

Qlik Academic Program

Qlik gives qualified university students, educators, and researchers free Qlik software and resources to prepare students for the data-driven workplace.

Community Sitemap

Here you will find a list of all the Qlik Community forums.

Recent Discussions

  • forum

    App Development

    Cumulative sum should not change based on selection

    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 cumulat... Show More

    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)))

    KNRaju105630_2-1679713211692.png

    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.

    KNRaju105630_0-1679714400855.png

     

    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!

     

     

    Show Less
  • forum

    QlikView App Dev

    I want to put 'A0' as the first two in this field.

    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 . . . Show More

    I have a field 'Lot '

    in field  'Lot ' contains data :

    Sxbbb_0-1679641314912.png

    I want to put 'A0' as the first two in this field.

    example :

    A0165052171

    A0172050012

    .

    .

    .

    Show Less
  • forum

    QlikView App Dev

    want to add '-' to count the 6th data from the left.

    I have a field 'Lot ' in field  'Lot ' contains data :   want to add '-' to count the 6th data from the left. EX 165052171 A0172050012         Show More

    I have a field 'Lot '

    in field  'Lot ' contains data :

    Sxbbb_0-1679643486797.png

     

    want to add '-' to count the 6th data from the left.

    EX

    165052171

    A0172050012

         

     

    Show Less
  • forum

    Qlik Application Automation

    How to move Qvd from a space to another

    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 s... Show More

    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.

    Show Less
  • forum

    New to Qlik Sense

    Subtotal one column of a table

    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 ... Show More
    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

    Show Less
  • forum

    GeoAnalytics

    Can't intersect two area

    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 r... Show More

    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:

    Connector reply error: grpc::StatusCode::INVALID_ARGUMENT: 'GEOOPS-401: Missing column in indata: Ikea_And_TravelArea'
    Emplacement de l'erreur:
    [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)


    Any clue ?

    Show Less
  • forum

    App Development

    Outer Set Expression field ignored when value not present in data set

    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 ... Show More

    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

    Show Less
  • forum

    New to Qlik Sense

    Arrange a number in ascending order

    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: Numbe... Show More

    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

     

     

    Show Less
  • forum

    App Development

    How to hide measure if its a null or 0 value in a chart?

    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 "... Show More

    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))

     

    Show Less
  • forum

    Qlik Cloud Data Integration

    Error connecting to Replicate server 'local_repsrv'

    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 bu... Show More

    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.

    Show Less

Blogs

Community News

Hear from your Community team as they tell you about updates to the Qlik Community Platform and more!

Blogs

Qlik Academic Program Blog

Read the latest blog around the Qlik Academic Program.

Blogs

Qlik Product Innovation Blog

If you want to know what's new across all of the products in our growing Qlik product portfolio.

Blogs

Support Updates Blog

Get the latest Support information about end-of-product support, new service releases, and general support topics.

Blogs

Qlik Design Blog

Read all about Qlik solutions: scripting, data modeling, visual design, extensions, best practices and more.

Location and Language Groups

Choose a Group

Join one of our Location and Language groups. Find one that suits you today!

Collaborate

Healthcare User Group

Healthcare User Group

A private group is for healthcare organizations, partners, and Qlik healthcare staff to collaborate and share insights..

All are welcome

Japan Group

Japan

Qlik Communityの日本語のグループです。 Qlik製品に関する日本語資料のダウンロードや質問を日本語で投稿することができます。

Request to join

Brasil Group

Brazil

Welcome to the group for Brazil users. .All discussions will be in Portuguese.

open to all

Events and Webinars

QlikWorld 2023, Technical Workshops!

10+ hours of roll up your sleeves, immersive working sessions. A $1000 value included in your conference pass!

Choose your workshops

Events and Webinars

Qlik and Qlik Community Hosted Events

Subscribe to our Events and Webinar page so you do not miss an event opportunity!

choose and register

Event

Welcome to Qlik

Join the "Welcome to Qlik" webinar and learn about the Qlik Ecosystem, such as Qlik Community, Learning, and Help.

On-Demand

Events

Upcoming Events and Webinars

There is more than one way to find upcoming events, look on the right side of any Qlik Community forum!

Upcoming

Events and Webinars

Qlik and Qlik Community Hosted Events

Subscribe to our Events and Webinar page so you do not miss an event opportunity!

choose and register

Event

Welcome to Qlik

Join the "Welcome to Qlik" webinar and learn about the Qlik Ecosystem, such as Qlik Community, Learning, and Help.

On-Demand

Events

Upcoming Events and Webinars

There is more than one way to find upcoming events, look on the right side of any Qlik Community forum!

Upcoming