Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 220,458 members
  • 3,529 online
  • 2,000,003 posts
  • 149,952 Solutions
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT

Welcome to Qlik Community

Recent Discussions

  • forum

    New to Qlik Analytics

    Count if status draft AND date occurred more than 3 days

    I am trying to set up a count for events that has been in the status draft for more than 3 days. I have setup the following: count ({<[Events: Inciden... Show More

    I am trying to set up a count for events that has been in the status draft for more than 3 days. I have setup the following:

    count ({<[Events: Incident Status]={'Draft'}>} isEvent and (Date(Now()))-([Events: Date occurred])>3)

    but it only takes the first part in the counting (counts all events in draft) and not only the events in draft for more than 3 days.

    Please help

    Show Less
  • forum

    New to Qlik Analytics

    variables with alternate state

    Hi, I have two tables one in alternate state 'state1' and one is in default state. I have created a variable to store selected vin value from alternat... Show More

    Hi,

    I have two tables one in alternate state 'state1' and one is in default state. I have created a variable to store selected vin value from alternate state table .

    var1= GetFieldSelections({'state1'} vin) 

    print this value in default table using

    $(var1)

    but this giving me result as dash (-). 

    How can i get the selected vin value in default state or any other state table. any suggestions please reply.

    Thanks.

     

    Show Less
  • forum

    App Development

    Apparent set analysis inconsistency

    Hello In my Datamodel there is a calendar, linked to the fact table, as usual…:   Now, the measure in the table below has a set analysis which select... Show More

    Hello

    In my Datamodel there is a calendar, linked to the fact table, as usual…:

    paolo_cordini_0-1716280209865.png

     

    Now, the measure in the table below has a set analysis which selects the dates above April 20th

    paolo_cordini_1-1716280209869.png

     

    The field “DataMovSettimana” contains the week, it is calculated in the script as Week(DataMov).

    As you can see, the current selection is DataMovSettimana=18.

    Then, as expected, the result is the intersection of the set analysis and the current selections, thus showing only dates pertaining to week 18.

    So, the result of the table below is the expected one.

     

     

     

     

    Then, I remove the dimension “DataMovSettimana” from the table, without modifying anything in the selections, and the result is shown below:

    paolo_cordini_2-1716280209871.png

     

    As you can see, the measure total value is different as it apparently disregards the selection of the week. Moreover, the espression “week(DataMov)” is not calculated for the dates excluded in the set analysis.

     

    Then, I remove one of the selections (not the week). Now the result is correct….

    paolo_cordini_3-1716280209873.png

     

     

     

    Moreover, how this can be explained?

    paolo_cordini_4-1716280209876.png

     

     

    In order to debug it, I made a copy of the date fields, both in the fact table and in the calendar table

    paolo_cordini_5-1716280209876.png

     

     

    paolo_cordini_6-1716280209877.png

     

    This is the result. Does it make sense? Anyway, it is a workaround for me in order to get correct results.

    paolo_cordini_7-1716280209879.png

    I guess there is some datamodel issue but I am running out of ideas to throubleshoot it.

    Any suggestion?

     

    Show Less
  • forum

    App Development

    Row level calculation in a table

    Hi, I need help to create this table in Qlik Sense. The Row A and B are coming from source, and I need to derive the row (highlighted in yellow) in Ql... Show More

    Hi,

    I need help to create this table in Qlik Sense. The Row A and B are coming from source, and I need to derive the row (highlighted in yellow) in Qlik using measure expression. Below the highlighted rows in yellow are the excel formula to drive the row-wise calculation.

    I need to do it in the table (chart) only, not in the script. Thank you for your time and support in advanced! 

    sk88024_0-1716415458226.png

    Thanks,

    SK

    Show Less
  • forum

    New to Qlik Analytics

    How to do KPI Money format

    Hi , I have a measure for KPI with below set expression =(Sum({<[OrderDate]={">=$(=YearStart(max([OrderDate])))<=$(=Max([OrderDate]))"}>} Sales))/1000... Show More

    Hi ,

    I have a measure for KPI with below set expression =(Sum({<[OrderDate]={">=$(=YearStart(max([OrderDate])))<=$(=Max([OrderDate]))"}>} Sales))/1000, for this value is like 4.3k , but i want to show $ 4.3k as output , so how to add $ symbol Infront of it or is there any other way to display KPI YTD value  like $ 4,3k instead of

    $ 4299865.87 .Here i have selected Number formatting as Money ($ ###0.00;-$ ###0.00)

     

    Regards.

    Show Less
  • forum

    Design and Development

    How to loop a tRestClient to fetch all data

    I aim to retrieve all the data from our Freshdesk ticketing system. However, I've encountered a limitation with the API, which only permits a maximum ... Show More

    I aim to retrieve all the data from our Freshdesk ticketing system. However, I've encountered a limitation with the API, which only permits a maximum of 100 data entries per page.

    As we have over 1,000 contacts to gather and store in our database, I'm currently facing a challenge in looping back to the tRESTClient to fetch the next set of data and appending it to my CSV file.

    Here's my current setup: tRESTClient -> tXMLMap -> tLogRow -> tFileOutputDelimited. My end goal is to be able to fetch all the contact details and store it to our MySQL DB. 

    I am very new at using Talend so any guidance on how to proceed would be greatly appreciated.

    Show Less
  • forum

    Qlik Cloud Data Integration

    I am not able to generate an API key

    Hello I am using a student account, Im the tenant and I have all privileges. Even that I have already consent the generation of API Keys and also I ha... Show More

    Hello I am using a student account, Im the tenant and I have all privileges. Even that I have already consent the generation of API Keys and also I have given me the role of developer.  

    When I try to generate an API key it throws me a message saying that the content im trying to acces is restricted or not accesible.

    crixox29_0-1716461995259.png

     

    Show Less
  • forum

    Qlik Replicate

    SAP note 3255746, change in terms and conditions

    Hello,  Recently SAP has announced change in their Terms & Co which does not permit (although no hard stop yet) SAP connection type: ODP through RFC. ... Show More

    Hello, 

    Recently SAP has announced change in their Terms & Co which does not permit (although no hard stop yet) SAP connection type: ODP through RFC. 

    Are there any plans for upgrades of SAP connector ?  Or it is already using different connection type and therefore its "future-proof" ? 

    Thank you in advance, 

    Show Less
  • forum

    Qlik NPrinting

    connection to SMTP Problem

    Hello,  When I make the configuration of the mail,I have this Error message and there is the log message "Failed to send e-mail message to xx@xx.com ... Show More

    Hello, 

    When I make the configuration of the mail,
    I have this Error message

    Anw_0-1716391661166.png

    and there is the log message

    "Failed to send e-mail message to xx@xx.com ERROR: System.Net.Sockets.SocketException (0x80004005): A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond 52.98.227.162:995↓↓ at System.Net.Sockets.Socket.DoConnect(EndPoint endPointSnapshot, SocketAddress socketAddress)↓↓ at System.Net.Sockets.Socket.Connect(EndPoint remoteEP)↓↓ at System.Net.Sockets.Socket.Connect(IPAddress address, Int32 port)↓↓ at MailKit.Net.Smtp.SmtpClient.Connect(String host, Int32 port, SecureSocketOptions options, CancellationToken cancellationToken)↓↓ at Qlik.NPrinting.Repo.Service.MailService.<SendEmailAsync>d__4.MoveNext() in C:\Jws\release-may2023-cw4ys0k9S\server\NPrinting\src\Repo\Service\MailService.cs:line 73"
    Can you help me please?


    PS:There is proxy installed in the Virtual Machine.

     

     

    Show Less
  • forum

    Qlik NPrinting

    NPrinting 16.9 installation files

    HelloI need these files because i need to install it on a server in wich we have that version of qlikview and the oldest version I can download from t... Show More

    Hello

    I need these files because i need to install it on a server in wich we have that version of qlikview and the oldest version I can download from the partner proteal is 21, is there any way I can get a hold on to this version files?

    Show Less
Leaderboard

Customer Story

Accelerating Decision-Making with Qlik Insights

Qlik enhances decision-making with high-speed insights, as Mayborn Group integrates data from various functions across their global operations, gaining a competitive edge in the childcare industry.

Customer Story

Efficiency in Agriculture: Nortera's Qlik Triumph

Nortera leads agricultural manufacturing analytics and automation with Qlik, reducing short-shipment rates and annual savings in water consumption.

Customer Story

Revolutionizing aircraft production through Data Analytics

Qlik Data Integration transforms Airbus' aircraft production, leading to over 150 replication tasks and informing more efficient analysis.

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

Blogs

Community News

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