Qlik Community

Welcome to Qlik Community

cancel
Showing results for 
Search instead for 
Did you mean: 
2,257 online

Here you will find Qlik Sense resources, partake in interesting discussions, solve problems and foster relationships with Qlik experts from around the globe.

Thank you for joining us in the QlikView Forum, your home for QlikView answers. Discover insights within your data that can transform your business.

Discussion board and documents related to Qlik Associative Big Data Index.

Find a forum to ask a question or start a discussion.

Information about additional Qlik opportunities and offerings.

Qlik partners with leading technology companies to develop integrations, extensions, and connectors to the Qlik platform.

Discussion Boards and Documents for Qlik Services.

View our Technical Blogs for updates and information.

Join one of our Qlik Community Groups. Anyone can view content in Open Groups, but you must join to participate. Closed Groups require joining in order to view content and participate.

Learn about the Qlik Community. Explore 'How-To' documentation, ask questions, and engage in discussion around the community platform. This will also be the place where, from time to time, we will do some fun things.

The Qlik Analytics Tour


AI in Action - The Qlik Analytics Tour


Looking for fresh approaches to using data – and using it to lead? Wish you could give everyone in your organization the power to drive competitive edge? Join us for AI in Action: The Qlik Analytics Tour, where we’ll explore the revolutionary new ways businesses are using the Qlik Sense® analytics platform to transform, reinvent, and pull ahead of the pack.

Recent Discussions

  • QlikView App Development

    Qlikview Performance

    Hi,We have a same dashboard present on Server A to Server B.We observed that the performance of the dashboard on Server B is slower than that of ... Show More

    Hi,

    We have a same dashboard present on Server A to Server B.

    We observed that the performance of the dashboard on Server B is slower than that of Server A.

    If the dashboards present on both the servers are exact same in design, data and memory.

    What are the others factors that are affecting the performance.

    What all factors should we compare on both the servers to figure out why the performance is slow on Server B.

     

    Kindly guide.

    Show Less
  • QlikView Scripting

    To get the nth ranked value for a dimension at script level

    Hi,I have a requirement where i need to get the nth ranked value for a dimension, sample table given belowThe Column Threshold value is what I want to... Show More

    Hi,

    I have a requirement where i need to get the nth ranked value for a dimension, sample table given below

    The Column Threshold value is what I want to compute.

    So we are looking at a range of dates for the customers and the indicator is computed on some logic.

    The Threshold value is based on the value in the indicator column. It is the nth rank value for each customer where n is the value in the indicator column.

    I have tried to use Firstsortedvalue and Max , but both need a number or a variable in the rank agreement. I want to use the indicator column.

    Formula i used :

    FirstSortedValue(Value,-Value,indicator) - gives wrong result

    Max(Value,indicator) -  gives wrong result

     

    I cannot give a fixed number in the last agreement of both the functions as it changes with customer. Please advise if any solution for this scenario.

    Date Customer Value indicatorThreshold value 
    1/1/2019a24420
    2/1/2019a56420
    3/1/2019a-75420
    4/1/2019a12420
    5/1/2019a45420
    6/1/2019a-10420
    7/1/2019a-5420
    8/1/2019a20420
    1/1/2019b634543
    2/1/2019b43543
    3/1/2019b454543
    4/1/2019b34543
    5/1/2019b463543
    6/1/2019b646543
    7/1/2019b43543
    8/1/2019b33543
         
    Show Less
  • New to QlikView

    Grouping values

    Hello,I have data for vehicle registration and Movement count. I want to group these not by serial but by count.e.g.  "16" movement count - 2 veh... Show More

    Hello,

    I have data for vehicle registration and Movement count. I want to group these not by serial but by count.

    e.g.  "16" movement count - 2 vehicles , 2% of all movements

    Thanks

     

    HN51 CWM	17
    GL52 XOO	16
    OJ69 BVU	16
    GS57 IGF	15
    UX69 UMP	15
    CM58 HNQ	15
    PA66 BSA	13
    RC63 IFF	13
    LT61 TTK	13
    KN57 GNM	13
    QP68 ZVX	13
    MI61 VJY	13
    JX65 RKR	12
    IT52 TZL	12
    HV61 EDP	12
    LS69 BBP	12
    IU52 NAK	12
    QV63 QYJ	12
    CO67 UNO	12
    BO58 HGZ	12
    TN59 ZPF	12
    TE53 SJV	11
    TA69 VME	11
    HY52 PIQ	11
    WY69 OCK	11
    DO63 PRF	11
    EU64 IBZ	11
    DF53 QNT	11
    NC64 MUY	11
    AU61 LAP	11
    LF55 OFF	11
    FM59 MIE	11
    XR67 KPE	11
    OA68 YZL	11
    KS67 PMK	11
    XU67 BGD	10
    MM66 BRN	10
    BJ65 IKA	10
    EN61 TKZ	10
    KZ67 WWW	10
    QO56 RGF	10
    FP65 XNX	10
    IO67 MIF	10
    LY66 IXU	10
    IE52 PPF	10
    CW62 VFU	10
    CS64 JBX	10
    TP63 IJU	10
    JF66 VAI	10
    YC63 IAJ	10
    JV57 ENE	10
    VQ59 QEG	10
    FC67 VNJ	10
    AI59 OXR	10
    MU53 BER	10
    HK62 ZNX	10
    TF66 VPB	10
    YN69 ONF	10
    ET67 CTQ	10
    EM55 ADB	10
    JR62 ZMN	10
    SG67 JUF	10
    AY52 PJP	10
    YI67 SSD	10
    QX66 VZB	10
    LG61 YVH	10
    UJ62 FEF	10
    SR61 IGU	10
    IK66 ZOO	10
    VY51 APV	10
    CJ57 VHH	10
    GY68 RLR	10
    DY59 OBI	10
    AH56 HTY	10
    CU56 PVL	10
    IG54 CAV	10
    JK63 DRH	10
    EL61 HMK	10
    ID62 UOF	9
    JK52 RLD	9
    MR51 FAE	9
    MK58 PFK	9
    YK62 YAX	9
    PJ67 NCN	9
    OQ64 GGN	9
    HH58 ZHK	9
    FL61 NFX	9
    AP53 XLK	9
    PC61 VRM	9
    JO55 YJD	9
    ST53 XRN	9
    AF53 GYI	9
    BQ56 BZF	9
    YC62 HMJ	9
    TQ53 ZZV	9
    NQ54 MXL	9
    CJ62 MIL	9
    LC51 XRD	9
    GY63 UGO	9
    GK53 SIL	9
    OT56 KDH	9
    KA53 SKT	9
    YJ59 CXB	9
    AG67 AKP	9
    VE58 KOX	9
    NN54 DRZ	9
    AO67 QZL	9
    VK56 SBM	9

     

    Show Less
  • New to Qlik Sense

    Rolling sum till selected month

    hi,I have problem in which the data is containing customer, month, year and sales and I will provide the data set below.I need the output as mentioned... Show More

    hi,

    I have problem in which the data is containing customer, month, year and sales and I will provide the data set below.I need the output as mentioned in the data set (sheet 2) please look into it ad provide me the solution.

    Thanking You in advance,

    Show Less
  • New to QlikView

    Hide macro buttons for Plugin users

    Is it possible to hide buttons (macros that launch Excel files mainly) that I as a developer use to access certain databases and mapping tables (mainl... Show More

    Is it possible to hide buttons (macros that launch Excel files mainly) that I as a developer use to access certain databases and mapping tables (mainly Excel files) from users using Qlikview via the plugin?

    Show Less
  • New to Qlik Sense

    How to Accumulates Sales Qty Rolling Starting From April to March

    Hi All,I have a requirement to accumulate sales qty starting from April to March in our fiscal year.So far i tried to create a formula but still did n... Show More

    Hi All,

    I have a requirement to accumulate sales qty starting from April to March in our fiscal year.

    So far i tried to create a formula but still did not get what i want because the value starting from January.

    this is my formula:

    Sum(Aggr(RangeSum(Above(TOTAL Sum({<
    [FiscalMonth]=
    >}
    QTY_W_SALES),0,RowNo(Total))),[FiscalMonth]))

     

    This is the result :

    fiscal_amount.jpg

     how can i get the proper formula to have "accum" value start summarizing in April not in January ?

    regarding our fiscal year starting in April.

     

    Thank You for your help,

    Tofanz

     

    Show Less
  • QlikView App Development

    how to extract month number from month name

    I want to extract month number from name in expression(measure).for example if month name is March it should return me 3. Kindly suggest me a function... Show More

    I want to extract month number from name in expression(measure).

    for example if month name is March it should return me 3. Kindly suggest me a function for that in qliksense.

    Show Less
  • New to Qlik Sense

    Table with Set Analysis expression: Identify specific characters and remove from...

    Hi all, after a little help as can't seem to find what I'm looking for.I have a list of Project Codes with 'WIP' amounts attached. All codes begin wit... Show More

    Hi all, after a little help as can't seem to find what I'm looking for.

    I have a list of Project Codes with 'WIP' amounts attached. All codes begin with 2 x letters, followed by a series of numbers i.e.

    AB12345       $1000

    BC54321       $5000

    ZA55567       $3200 etc...

    There are some Project Codes however, that only begin with 1 x letter i.e. N02345, B098765, N755547 etc.

    I currently use SET ANALYSIS to identify WIP:     sum({$<WORD_STATUS = {"WIP"}, COST_MIX = {*} >} TOT_AMT)

    I'm not sure if I can just add to this expression or need to go another way?

    I want to do the following: ... When a Project Code begins with only 1 x letter, then exclude those Project Codes from TOT_AMT. This will leave me with only the WIP Amounts for Project Codes with 2 x letters followed by a number series.

    The letter could be any letter from the Alphabet so needs to include some kind of Wild Card.

    Thanks in advance.

    Show Less
  • New to QlikView

    Not able to add listbox number into date in count expression

    I have the ListBox to select or enter some number in user input box .Based on the selection value from my ListBox or Input Box value, my count automat... Show More

    I have the ListBox to select or enter some number in user input box .
    Based on the selection value from my ListBox or Input Box value, my count automatically should change automatically.
    For Example,
    if i select one number from my ListBox(ListBox Name : SeqDays) , then my count should get change automatically.

    What i have done so for as mentioned below steps

    1. I created one variable and assign those variable to "SeqDays" ListBox.
          vUserInput =GetFieldSelections(SeqDays) ==> // ListBox values assigned to vUserInput variable

    2. I have applied for one expression in a PIE CHART (i.e) ==> < 5 Days (Expression).
         below is my expression.
         =Count({<NewDate={">=$(vCalDate)<=$(vToday) + $(vUserInput)"}>} NewDate)

    3. My other variables

         vCalDate=date(vToday-5,'DD-MM-YYYY')

         vToday=date(Today(),'DD-MM-YYYY')

    My Requirement is,

    I just want to add listbox value "vUserInput" into my date condition expression (>=$(vCalDate)<=$(vToday) )in to the condition.
    I tried many ways. but, no way to track and get the userinput values. It is not working. count will not be changing based on my "SeqDays" selection.

    What might be the problem.?????

    pls. find attached sample file with condition i used...

    Note : I tried to solve this issue for long time. but, not getting proper solution.

    Show Less
  • QlikView App Development

    Qlikview 12.20, Pivot Table Sorting Issue

    Hi,We have Qlikview 12.20 installed on our machines.When we open a dashboard, originally developed in Qlikview 11.20, in the Qlikview 12.20, then the ... Show More

    Hi,

    We have Qlikview 12.20 installed on our machines.

    When we open a dashboard, originally developed in Qlikview 11.20, in the Qlikview 12.20, then the sort order in the pivot tables is breaking.

    Is this a known behavior of Qlikview, that when a document developed in 11.20, opened in 12.20, the sort order in pivot table breaks?

    kindly clarify.

    Show Less

Blogs

Qlik Community Blogs

Check out our community blogs to stay current on the latest and greatest information about Qlik products.

7 Blogs

Groups

Join a Group

Join one of our Qlik Community groups related to an Industry, Location, Language, or Topic.

28 Groups

Events

Events & Meetups

Participate in an upcoming Qlik related event, webinar, or local meetup.