Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 172,956 members
  • 6,453 online
  • 1,792,718 posts
  • 137,071 Solutions
Announcements
Meet our latest featured member Bruno! Drop a like and comment. READ ON

Welcome to Qlik Community

Recent Discussions

  • forum

    New to Qlik Sense

    Null check the result of a variable

    I have a variable that formats a string in a particular manner and returns the string. There are instances where this will return a null, which is by ... Show More

    I have a variable that formats a string in a particular manner and returns the string. There are instances where this will return a null, which is by design. However, instead of it returning - (the qlik representation of null), I would like to to return a string 'Empty'.

    Variable is vConcat_String

    if I do: LEN($(vConcat_String)) I get the length of the strings returned if there is a string to return, but on null, I still get '-'. 

    I have tried wrapping it in an isnull() function like: =if(isnull($(vConcat_String)), 'Empty', $(vConcat_String)) and it continues to express null values to '-' in the table.  I have also tried LEN: if(LEN($(vConcat_String)>1, $(vConcat_String), 'Empty') but the null value still expresses to '-' instead of 'Empty'.

    Any suggestions?

    Show Less
  • forum

    Insight Advisor

    Cumulative issue

      Hi using this formula to calculate cumulative but its not working - works for a few lines then seems not to work   RangeSum(Above(SUM(SUBMITTED_THP... Show More

    RobMazaheri_0-1695206358583.png

     

    Hi using this formula to calculate cumulative but its not working - works for a few lines then seems not to work

     

    RangeSum(Above(SUM(SUBMITTED_THP),0,3)) 

     

    I know its not possible to do a cumulative view in pivot as if there is a zero it cant see past that value 

    Show Less
  • forum

    Qlik Replicate

    Error while connecting to redshift target.

    Hi Team, I am getting below error while connecting to the redshift target. SYS-E-DESERIALERR, Failed to deserialize json to type BrowseConnectionAsyn... Show More

    Hi Team,

    I am getting below error while connecting to the redshift target.

    • SYS-E-DESERIALERR, Failed to deserialize json to type BrowseConnectionAsyncReq: Unexpected character encountered while parsing value: {. Path 'db_info.db_settings.s3Region', line 1, position 282..
    • SYS,DESERIALIZE_TO_TYPE,BrowseConnectionAsyncReq,Unexpected character encountered while parsing value: {. Path 'db_info.db_settings.s3Region', line 1, position 282

    While I am able to connect from production server. since this is poc instance for redshift. I need to connect it from the Poc server but I am getting above error.

    please help us to resolve this issue.

    Regards,

    Sushant

    Show Less
  • forum

    Catalog and Lineage

    Is possible to have always a value of date selected and set the max date as defa...

    I want that a unique value of date is selected and set the max date as default when the app is opened. But the interaction between this two issues doe... Show More

    I want that a unique value of date is selected and set the max date as default when the app is opened. But the interaction between this two issues does not seem to work well. Anyone knows how could I do it?

    Thank you in advance

    Show Less
  • forum

    New to Qlik Sense

    How to hide data for Days = 0

    I am using a Master Calendar for my data model. Data for one set of Load don't have data Post 12th. But the other has data till 20th.  Due to this I a... Show More

    I am using a Master Calendar for my data model. Data for one set of Load don't have data Post 12th.

    But the other has data till 20th. 

    Due to this I am able to see 0 for the days where there is no Data.

    how I can make the view dynamic across sheets.

    below is the image where i don't have data post 12th.

    kaushi2020_0-1695299726921.png

     

    Below is the one where I have Data till 20th.

    kaushi2020_1-1695300429850.png

    How I can control the Bar chart where I don't have data Post 12 so that it don't show chart where the data is null.

     

     

     

     

    Show Less
  • forum

    Move to SaaS

    Totals text is not clear on charts in QlikSense cloud

    Hi,  I have recently started using Qlik sense cloud and we are using Qliksense November 2022 Patch 7 version of the app. When try to get the totals on... Show More

    Hi, 

    I have recently started using Qlik sense cloud and we are using Qliksense November 2022 Patch 7 version of the app. When try to get the totals on top of a bar chart. The text for the total is not clearly visible. Sometimes it is not even readable. I've never faced this issue before but this has been the case ever since we moved to the cloud. 

    Is there anything I can do to fix this? Please see the attached screenshot

    Thanks in advance

     

    Qlik Sense Business Qlik Cloud 

    Show Less
  • forum

    Connectivity & Data Prep

    Fractile function to delete outliers

    Hello, I'm trying to use the Fractile() function to delete outliers from my table, but I can't manage to make it work. Documentation specifying a gen... Show More

    LeonardoB25_0-1695295352582.png

    Hello, I'm trying to use the Fractile() function to delete outliers from my table, but I can't manage to make it work. Documentation specifying a general <expr> in the first function clause doesn't help either.

    I have a numeric colum (Valore Riga) and I just want to keep the most central 99% of data, in order to exclude extreme values from the dataset.

    Thanks in advance.

    Show Less
  • forum

    New to Qlik Sense

    Qlik Sense Info

    Hi I am new to Qlik Sense and currently using its Qlik Sense Cloud application. I have few queries if anyone can guide me: 1. In pricing section, it s... Show More

    Hi

    I am new to Qlik Sense and currently using its Qlik Sense Cloud application. I have few queries if anyone can guide me:

    1. In pricing section, it says 50GB/Year Storage Capacity. So if i remove any dataset from the app or cloud storage, will the storage space be restored back?

    2. I have noticed that once you create a new app and upload files in it, they don't get organized in a folder within that app you created. How can you organize the files in a folder?

    3. I see that I can delete the created but the files that were loaded in it remains and there is no option to delete them. How to do it?

    4. How to select first or second row as a header once the file has been uploaded?

    5. How can I custom design report or storytelling templates?

    6. Is there any option to share the report or visuals in sheet window to public?

    7. List of most commonly used calculated functions in Qlik Sense?

    8. Best place to learn Qlik Sense advanced and its URL

    Will appreciate if someone can answer the above.

    Regards,

    Sal

    Show Less
  • forum

    New to Qlik Sense

    QSBA Certification Quiz : Confusion Regarding a Business Analysis Question

          Is here asking only for one solution?   Hello everyone, I recently encountered a business analysis question that has left me quite puzzled, and ... Show More

     

     

    Is here asking only for one solution?

     

    Hello everyone,

    I recently encountered a business analysis question that has left me quite puzzled, and I would like to seek your insights and opinions on the matter.

    The question asked for a calculated expression to display "current year sales versus previous year sales" in a table. However, the phrasing of the question seems to be open to interpretation, which has led to my confusion.

    here is the quiz and answer:

     

    wpe_0-1695297256201.png

     

    The provided standard answer is:

    Sum({$<OrderYear = {$(=Year(Today()))}>} Sales)

     

     

    My proposed alternative answer is:

    Sum({$<OrderYear = {$(=Year(Today())-1)}>} Sales)

     

    This expression calculates the sum of sales for the current year, which I think is also relevant for the comparison. 

    as I was only allowed to choice one answer. but in the questions it asked plural. 

     

    Should the question be interpreted to focus solely on the previous year's sales, or is it reasonable to include the current year's sales for a comprehensive year-over-year analysis? what do you think? It is just so confusing. 

     

     

     

     

    Show Less
  • forum

    New to Qlik Sense

    Setting a constant filter & Using a variable as a filter

    Hi experts, I have a big mess with the filters and the set analysis, I have several problems.I am using 4 main variables - 2 are for the KPIs and 2 ar... Show More

    Hi experts,

    I have a big mess with the filters and the set analysis, I have several problems.
    I am using 4 main variables - 2 are for the KPIs and 2 are for the other objects.

    For each KPI I am using Set Analysis and define each variable to the relevant field.
    For example: Sum({<Year={'$(vKpiYear)'}, Month={'$(vKpiMonth)'}, Flag1={1}>}Sales)
    The KPIs should not be affected by any user selection, not even selections in the fields listed in the Set Analysis.
    When I added 1 to the Set Analysis, only the mentioned fields (Year, Month, Flag1) affect the KPIs, but that shouldn't happen either.
    Sum({1<Year={'$(vKpiYear)'}, Month={'$(vKpiMonth)'}, Flag1={1}>}Sales)

    The rest of the objects should affect by user selection in the filter panes.
    I need to use the other 2 variables to set a default filter in a filter pane (a dynamic filter that updated every month) - set the value of vSelYear as default of Year and set the value of vSelMonth as default of Month. The user can change this defauld and filter by additional fields. Every selection will affect all objects except the KPIs.
    My problem is associating the variable value to a field in the filter panes.

    The client prefers that I not use Alternate State for the first problem and refuses to use extension for the second problem.
    How can the problems be solved?

    Hope I was clear. Many Thanks!

    Show Less
Leaderboard

Leaderboard

Epsum factorial non deposit quid pro quo hic escorol.

Customer Story

New Data Integration Customer Story + Video

Real-time Responses Delight Burgan Bank's Customers.

Customer Story

Talking Analytics to the Frontier

Alaska’s Northrim Bank wins the SBA Lender of the Year award, using Qlik to target unique local needs.

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!