Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 214,375 members
  • 6,157 online
  • 1,989,693 posts
  • 149,032 Solutions
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP

Welcome to Qlik Community

Recent Discussions

  • forum

    App Development

    Using an Input Box for Script

    Hello,   I'm using an InputBox to use the variable in the script, but the variable in the Input Box is defined with an function expression as 'Num(Get... Show More

    Hello,

     

    I'm using an InputBox to use the variable in the script, but the variable in the Input Box is defined with an function expression as 'Num(GetFieldSelections(X))' and then in the script Qlik use the text of the function and not the value of the function.

     

    What must I do, to have only a value

    Show Less
  • forum

    App Development

    Create fiscal year calendar in Qliksense

    Hello , I want to create a fiscal year master calendar and I have used the below script :- //-- Fiscal year Mastr Calendar---// QuartersMap:MAPPING LO... Show More

    Hello ,

    I want to create a fiscal year master calendar and I have used the below script :-

    //-- Fiscal year Mastr Calendar---//

    QuartersMap:
    MAPPING LOAD
    rowno() as Month,
    'Q' & Ceil (rowno()/3) as Quarter
    AUTOGENERATE (12);
    Temp:
    Load
    min(EMLC_OK_DATE) as minDate,
    max(EMLC_OK_DATE) as maxDate
    Resident ZZ_FF_BUILD_DETAIL_DAILY;
    Let varMinDate = Num(Peek('minDate', 0, 'Temp'));
    Let varMaxDate = Num(Peek('maxDate', 0, 'Temp'));
    DROP Table Temp;
    TempCalendar:
    LOAD
    $(varMinDate) + Iterno()-1 As Num,
    Date($(varMinDate) + IterNo() - 1) as TempDate
    AutoGenerate 1 While $(varMinDate) + IterNo() -1 <= $(varMaxDate);
    MasterCalendar:
    Load
    TempDate AS EMLC_OK_DATE,
    week(TempDate) As RFS_Fiscal_Week,
    Year(TempDate) As RFS_Fiscal_Year,
    Month(TempDate) As RFS_Foscal_Month,
    Day(TempDate) As Day,
    // YeartoDate(TempDate)*-1 as CurYTDFlag,
    //YeartoDate(TempDate,-1)*-1 as LastYTDFlag,
    inyear(TempDate, Monthstart($(varMaxDate)),-1) as RC12,
    date(monthstart(TempDate), 'MMM-YYYY') as RFS_Fiscal_MonthYear,
    ApplyMap('QuartersMap', month(TempDate), Null()) as RFS_Fiscal_Quarter,
    Week(weekstart(TempDate)) & '-' & WeekYear(TempDate) as RFS_Fiscal_WeekYear,
    QuarterName(AddMonths(TempDate,3)) as RFS_Fiscal_QuarterName,
    WeekDay(TempDate) as RFS_Fiscal_WeekDay
    Resident TempCalendar
    Order By TempDate ASC;
    Drop Table TempCalendar;

    exit script;

    //==============================//

    But I am not getting the proper output. Please see below :-

    Aspiring_Developer_0-1710776674163.png

    Not sure, what mistake I made in the above script. Can anyone please help me ?

    Thanks in advance

    @sunny_talwar 

    Show Less
  • forum

    Security & Governance

    Critical Security fixes for Qlik Sense Enterprise for Windows (CVE-2023-48365) a...

    our products is Qlik sense 2023 may patch 4 and server 2016.  found risk Critical Security fixes for Qlik Sense Enterprise for Windows (CVE-2023-48365... Show More

    our products is Qlik sense 2023 may patch 4 and server 2016. 

    found risk Critical Security fixes for Qlik Sense Enterprise for Windows (CVE-2023-48365)

    I want to update with 2023 may patch 6. 

    But could not successful update and tell me patch 4 could not uninstall. 

    how to deal with ?

    detail see attached documents.

    jens

    Show Less
  • forum

    New to Qlik Analytics

    aggr function returning null.

    Hi everyone, When attempting to retrieve the distinct count of 'app_yhno' across Splty a few values are null. count(distinct app_yhno) gives counts ac... Show More

    Hi everyone,

    When attempting to retrieve the distinct count of 'app_yhno' across Splty a few values are null.

    count(distinct app_yhno) gives counts across all dimensions, whereas applying the aggregation function aggr(count(distinct app_yhno), Splty) only produces values randomly and returns null value.

    Specifically, the aim is to obtain a value of 18 for all Anaesthesia in the provided image.

    yh2023_0-1710849372275.png

     

    Any help is greatly appreciated.

    Show Less
  • forum

    App Development

    Strange Section Access mystery

    Hello, We're seeing a strange situation with our Section Access that we've never seen before.  We have a Subjects table in our database with a field (... Show More

    Hello,

    We're seeing a strange situation with our Section Access that we've never seen before. 

    We have a Subjects table in our database with a field (SubjID) who's data type is (PK, int, not null). The values are straight forward. For example: 

    SubjID Name
    1 Bob Smith
    2 Jim Longley
    3 Sarah Whitely

     

    Our section access query is:

    SQL select 'USER' as "ACCESS", upper('MYDOMAIN\MYUSERID') as "USERID", '*' as "GROUP", null as "OMIT", SubjID as "Subject"  from Subjects;

    Our application body has the following query:

    [Subjects]:

    SQL select SubjID as Subject, Name from Subjects;

    The above does not work; the table is read but I get no access to the data. However, if I change the above query to the following:

    [Subjects]:

    Load *, num(SubjID,'0') as Subject;

    SQL select SubjID, Name from Subjects;

    The above does work. Any idea why the internal representation of the Subject field in the Section Access query would differ from the representation of the same field in the [Subjects] table, such that section access works in one case but not the other? 

     Thanks,

    Steven

    Show Less
  • forum

    New to Qlik Analytics

    How can i convert rows to column in pivot table

    This is the sheet that I created in Tableau. How can I replicate it in QlikView? The values are the sum of sales (in the block). I have tried creatin... Show More

    Madhura_0-1710852351240.png

    This is the sheet that I created in Tableau. How can I replicate it in QlikView? The values are the sum of sales (in the block). I have tried creating a pivot table, but I can't get months as columns; all months are in one column instead of different columns. Thanks in advance.

     

    Show Less
  • forum

    Brasil

    Automatizar carregamento de dados de um qvw no Access Point

    Bom dia pessoal,Sabem se existe uma forma de fazer com que um qvw seja automaticamente carregado todos os dias pela manhã? Como se fosse simular um "c... Show More

    Bom dia pessoal,

    Sabem se existe uma forma de fazer com que um qvw seja automaticamente carregado todos os dias pela manhã? Como se fosse simular um "clique" do cliente no qvw, via Access Point?
    O motivo é que tenho um dashboard que demora muito tempo para ser carregado no browser, e se fosse possível deixar ele previamente carregado, quando o cliente fosse acessar o dashboard, ele abriria mais rápido na tela.

    Desde já agradeço a ajuda!

    Show Less
  • forum

    App Development

    Exporting currency in correct format

    Hello all, I want the following output, e.g.: 0 should be displayed and exported as 0 € 5000 should be displayed and exported as 5.000,00 €   Ide... Show More

    Hello all,

    I want the following output, e.g.:

    • 0 should be displayed and exported as 0 €
    • 5000 should be displayed and exported as 5.000,00 €

     

    Idea No. Formula Number Format Displayed Output in Qlik Sense Exported Output in Excel
    1 =Money(round(..., .01)) Automatically
    1. 0 €
    2. 5.000,00 €
    1. 000 €
    2. 5.000 €
    2 =round(..., .01) Currency with: #.##0,00 €;-#.##0,00 €
    1. 0 €
    2. 5.000,00 €
    1. ,000 €
    2. 5000,000 €

     

    My analytics team always export with the tick in keeping the table format, because they want to keep the colors. Therefore their output in excel is like the exported output in excel as above. Not ticking would be a solution for the decimals, but will remove the colored cells.

     

    Why is my displayed output different to the exported output and how can I change that? 

    Show Less
  • forum

    New to Qlik Analytics

    Calculating sum in a loop

    Hello,   Perhaps somebody can help me with a problem I'm having. I have the following QVD: Test: LOAD CompanyId, DateId, StartingDate, EndDate, Revenu... Show More

    Hello,

     

    Perhaps somebody can help me with a problem I'm having. I have the following QVD:

    Test:

    LOAD

    CompanyId,

    DateId,

    StartingDate,

    EndDate,

    Revenue

    The EndDate field value is always the same as the DateId (I use DateId for a different left keep, so I want to keep it that way). StartingDate is a calculated value and depending on DateId always a year plus 1 day back. So if DateId is 1-1-2024, StartingDate value will be 2-1-2023. For each DateId I have a calculated revenue (it is a number field). I want to know the total sum of all the revenue values between the given starting and enddate. So if my value on StartingDate is 2-1-2023, my DateId and EndDate will be 1-1-2024. In the loop it needs to calculate the sum of all the revenue values between the StartingDate and the EndDate. If the starting date is 3-1-2023 and the end date is 2-1-2024, I want the total sum of all the revenue values that fall between those dates. When I have these totals, I can then continue with my script and determine a total value for revenue in the past 12 months for each DateId.

     

    What I would like to do is the following:

    LET loopDate = MAKEDATE(2019,1,1);

    DO WHILE loopDate <= MAKEDATE(TODAY())

    LOAD
    CompanyId,
    SUM(Revenue) AS Total
    RESIDENT Test
    WHERE StartingDate >= NUM($(loopDate)) AND EndDate <= NUM(TODAY())
    GROUP BY CompanyId;

    LET loopDate = loopDate + 1;

    LOOP

    This loop isn't working however. Can you please help me with this? 

    If you need any additional information, please let me know.

    Show Less
  • forum

    Qlik Replicate

    Qlik Replicate Filter Expression

    Hi everyone, I wanted to apply the below filter on replicate but dont know whats the correct syntax for that , can someone help me on this select * fr... Show More

    Hi everyone,

    I wanted to apply the below filter on replicate but dont know whats the correct syntax for that , can someone help me on this

    select * from CMS_BDR_AGG_GROUP where keysum not in (select distinct '%X'||agg_id||'X%' as keysum from CMS_REF_AGG where (agg_type=3 and NAME='HBCA') OR (agg_type=2 and NAME like '%HBCA%')) ;

    MSSOT_RIVA_HSBC1_0-1710822642487.png

    MSSOT_RIVA_HSBC1_1-1710822844065.png

     

    Show Less
Leaderboard

Customer Story

Qlik Data Integration & Qlik Replicate story

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.

Customer Story

Building a Collaborative Analytics Space

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.

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!