Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 214,323 members
  • 6,147 online
  • 1,989,552 posts
  • 149,023 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

    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

    New to Qlik Analytics

    I want to plot the average order quantity on the chart.

    Hello, I want to take avarage. The chart shows sales amounts on a weekly basis. I want to plot the average order quantity on the chart. In straight l... Show More

    Ekran görüntüsü 2024-03-19 101309.png

    Hello, I want to take avarage. The chart shows sales amounts on a weekly basis. I want to plot the average order quantity on the chart. In straight line shape.

    Show Less
  • forum

    Move to SaaS

    Difference between standard app size and app reload RAM?

    I have some confusion regarding the following topics. Can anyone please clarify? What is the difference between App Size (in memory size), App Reload... Show More

    I have some confusion regarding the following topics. Can anyone please clarify?

    1. What is the difference between App Size (in memory size), App Reload RAM, App RAM Footprint, and App Peak Reload Memory?
    2. We are using Qlik Sense SaaS. If the standard app size is 5GB, what is the peak reload size for apps in spaces without large app support, is it 40 or 50 GB?"
    Show Less
  • forum

    Qlik Replicate

    Error 1045 (Plugin caching_sha2_password could not be loaded

    while replicating the task we are getting below error. Error 1045 (Plugin caching_sha2_password could not be loaded:
  • forum

    New to Qlik Analytics

    Change mesures name in a pivot table

    Hello , I have a pivot table with: Dimension: Matricule , Nom Column: Type( Frais or Gain) Mesures : GH,GM,SIP i want to change  the name of the mesu... Show More

    Hello ,

    I have a pivot table with:

    Dimension: Matricule , Nom

    Column: Type( Frais or Gain)

    Mesures : GH,GM,SIP

    RanMH_0-1710771378490.png

    i want to change  the name of the mesures based on the value of the column "Type"

    Exemple If Type='Gain' and mesure = GH then the mesure name will be "Gain GH"

    RanMH_1-1710771462274.png

    I used this formula as a name of the mesure : if(wildmatch(Type,'Gain'),'Gain GH', 'Frais GH') but it's not working it gives the same value everywhere 

    Is there a way to do this ?

    Thank you in advance.

     

     

     

    Show Less
  • forum

    Qlik Reporting Service

    add chart image in body

    Hi Team,   We are working on one SaaS requirement, where we want to send mail to users and in that mail we have to do 2 activity 1: attached excel ( o... Show More

    Hi Team,

     

    We are working on one SaaS requirement, where we want to send mail to users and in that mail we have to do 2 activity

    1: attached excel ( output of one object)

    2: add chart image in body.

    We are able to achieve both individually but user need one single mail with both required results. 

    How can we achieve it? Your thought/suggestion will really helpful for me.

     

    Regards,

    Prashant Sangle

    Show Less
  • forum

    New to Qlik Analytics

    After updating my Qlik Sense to the February 2024 Patch 01 version, my hub does ...

    I use Windows 11, 64-bit 23H2, with 16 GB of RAM. I was using Qlik Sense Desktop November 2033 Patch 2 and everything was working fine. Today, I upgra... Show More

    I use Windows 11, 64-bit 23H2, with 16 GB of RAM. I was using Qlik Sense Desktop November 2033 Patch 2 and everything was working fine. Today, I upgraded my version of Qlik Sense Desktop to the February 2024 Patch, and Qlik opens normally without any error codes or alert messages.

    However, when I maximize Qlik to my full HD resolution, the Qlik window fills the screen, but the hub where the applications are located doesn't fill the screen. It appears as a square aligned to the left. I will attach a screenshot for reference.

    Have you seen this issue before?


    Note: I have hidden the names of the applications and the company logo in the screenshot.

    Show Less
  • forum

    New to Qlik Analytics

    Color Expression issue with Dimension group

    Hi Team, I've created a bar graph in Qlik, where I've organized the data by month to visualize both January and February. Each bar represents four mon... Show More

    Hi Team,

    I've created a bar graph in Qlik, where I've organized the data by month to visualize both January and February. Each bar represents four months of data; for example, in the January bar graph, I'm displaying data from October, November, December, and January. I've implemented a condition in the graph where the color of the bar changes based on certain criteria. If the percentage of the smallest month's classification is less than 100%, the bar turns red. If it equals 100%, the bar turns green. Otherwise, all other months will be represented in blue. This condition is working correctly for January, but not for February. What might be the reason for this discrepancy?
     
    Formula used in Color expression:
     
    if((['Month-Year']) = Min(total(['Month-Year'])) and [Percentage Classified] < '100.0%' and ['Month-Month'] = 'January' or ['Month-Month'] = 'February', 'Red', 
    If((['Month-Year']) = Min(total(['Month-Year'])) and [Percentage Classified] = '100.0%' and ['Month-Month'] = 'January' or ['Month-Month'] = 'February', 'Green', 'Blue'))

     

    Attached are the visualization that i need and currently i am getting

     

    @sunny_talwar Qlik Sense Business 

    Show Less
  • forum

    Qlik Enterprise Manager

    Analytics & DST

    My QR & QEM sit on 2XAWS EC2 instances, Windows OS. Timezone EST/EDT. Analytics Repository is AWS Aurora (Postrgres).According to AWS the default is U... Show More

    My QR & QEM sit on 2XAWS EC2 instances, Windows OS. Timezone EST/EDT.

    Analytics Repository is AWS Aurora (Postrgres).According to AWS the default is UTC.

    My Analytics data (retrieval_time) is showing as matching Eastern Time values.

    What I'm concerned about is (a) I need all my analytic data to be stamped by UTC and (b) conversions become complicated with DST.

    What is the best way to get my analytics data by UTC time?

    I have thought of altering the TZ at the windows OS level, but concerns this could affect other dependencies like maintenance & patching processes.

    Any "best practices" anyone could share?

    Thanks.

    Show Less
  • forum

    App Development

    How to create incremental load using 2 fields ?

    Hi I trying to write script of an incremental load using 2 fields (VehicleID , RowID). I would appreciate your help in writing the code for the proces... Show More

    Hi

    I trying to write script of an incremental load using 2 fields (VehicleID , RowID).

    I would appreciate your help in writing the code for the process of incremental loading.

    I want to take each time the new Data (Increment), which does not appear in the existing table, and add it to the existing data (Initial Data) and update if data was changed. 

    Thanks. 

    Initial Data: 

    VehicleID RowID
    12345 1
    12345 2
    12345 3
    21212 1

     

    Increment: 

    VehicleID RowID
    12345 4
    21212 2
    34343 1
    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!