Qlik Community

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

QlikView

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

QlikView and Qlik Sense are better together!

Maximize your Qlik investment with QlikView and Qlik Sense dual-use licensing.

The Qlik dual-use licensing offer provides a cost-effective way to adopt Qlik Sense across your entire QlikView user base.

Learn More

Questions & Discussions Documents & Videos

Recent Discussions

Recent Unanswered Unsolved Solved
  • New to QlikView

    Fuzzy Search in Qlikview

    Hi,   Is Fuzzy search checking for only one character at the time? Is it correct?Thanks,Krishna.
  • New to QlikView

    Use Calculated Expression as a conditional dimenstion

    Hello,I am working on building a QlikView dashboard. On a straight table, I have a calculated expression (which is count number of files in my data). ... Show More

    Hello,

    I am working on building a QlikView dashboard. On a straight table, I have a calculated expression (which is count number of files in my data). I want to have a conditional dimension if the user clicks on the calculated expression. How do I use the calculated expression of count in the conditional dimension?

    Show Less
  • QlikView Integration

    DIV Integration Issue

    I am trying to use the DIV Integration . we are using QV Server 12. Licensed Work Bench in LEF. Trying to integrate a list box as a starting point . U... Show More

    I am trying to use the DIV Integration . we are using QV Server 12. Licensed Work Bench in LEF. Trying to integrate a list box as a starting point . Using the below code. 

    Please see the attached error code. Any idea what am I missing?

    <!doctype html>
    <html lang="en">
    <head>
    <meta charset="utf-8">
    <title>The HTML5 Herald</title>
    <meta name="description" content="The HTML5 Herald">
    <meta name="author" content="SitePoint">
    <style>
    .QvInlineObject
    {
    position:relative;
    margin-left:10px;
    margin-right:10px;
    float:left;
    }
    </style>
    <script language="javascript" type="text/javascript" src="https://server URL/QvAJAXZfc/htc/QvAjax.js"></script>
    <script language="javascript" type="text/javascript">
    Qv.InitWorkBench({
    View: 'Sample_App',
    // Instead of using "Host: 'Local'", use "Host: null"
    Host: QVS@ProdCluster
    });
    </script>
    </head>
    <body>
    <div class="QvInlineObject" avqview="Sample_App" avq="object:.Document\LB02" id="Document\LB02"></div>
    </body>
    </html>

    Show Less
  • New to QlikView

    What logs are needed to generate CPU and Memory charts in SCResultAnalyser App

    I am using QVScalability tool for performance testing of Qlikview app. and later i am trying to analyse its results using SCResult Analyser tool. ... Show More

    I am using QVScalability tool for performance testing of Qlikview app. and later i am trying to analyse its results using SCResult Analyser tool. 

    Added All logs under respective folder as below, 

    Eventlogs,JmeterLogs,QVDs generated from QVDGenerator, ServerLogs, SessionLogs, TestLogMeta.txt(auto generated from QVD generator)

    Irrespective of all the logs, It is not generating CPU and Memory Charts in SCResult Analyser App. What logs are needed to generate for CPU and Memory charts and in which folder we have to put them ? 

    Please provide inputs on this.

     

    ScResultAnalyserApp-MemoryAndCPUcharts.png

    Show Less
  • QlikView Creating Analytics

    QlikView App: How to add actions on a button to highlight text in a textbox on t...

  • QlikView App Development

    Extracting sharepoint list data into QlikView

    Hello,I'm trying to extract sharepoint list data into QlikView but I got this issue "Couldn't connect to server".My link:  https://mycompany... Show More

    Hello,

    I'm trying to extract sharepoint list data into QlikView but I got this issue "Couldn't connect to server".

    My link:  https://mycompany.sharepoint.com/sites/.../.../_vti_bin/owssvr.dll?Cmd=Display&XMLDATA=1&RowLimit=0&List={02C0ACAB-C3B1-4E82-9BE6-2E819F3EA4CA}

    Do you have any idea about this error?

    Thank you for your help!

    I followed this link

     

    Show Less
  • QlikView App Development

    Issue with stripHTML function in QlikView

    Hello Everyone,I am trying to eliminate html codes from my data using stripHTML function. I am using the below macro for the same,Function stripHTML(s... Show More

    Hello Everyone,

    I am trying to eliminate html codes from my data using stripHTML function. I am using the below macro for the same,

    Function stripHTML(strHTML)
    'Strips the HTML tags from strHTML

    Dim objRegExp, strOutput
    Set objRegExp = New Regexp

    objRegExp.IgnoreCase = True
    objRegExp.Global = True
    objRegExp.Pattern = "(?:<style.+?>.+?</style>|<script.+?>.+?</script>|<(?:!|/?[a-zA-Z]+).*?/?>)"

    'Replace all HTML tag matches with the empty string
    strOutput = objRegExp.Replace(strHTML, "")

    'Replace all < and > with &lt; and &gt;
    strOutput = Replace(strOutput, "&lt;", "<")
    strOutput = Replace(strOutput, "&gt;", ">")

    stripHTML = strOutput 'Return the value of strOutput

    Set objRegExp = Nothing
    End Function

    The issue is, when I reload the report locally in my server, the report executes without any errors, but when reloaded on QMC, I get the below error

    PR error msg.PNG

    Any guesses what could be the possible reason for this? 

    Thank you.

    Show Less
  • QlikView Publisher

    Qlikview QMC Task Skipped || application didnt reload as per daily schedule

    Hello ,I have an application where the schedule is auto triggered everyday but i could see that the application didnt reload for a day and so there is... Show More

    Hello ,

    I have an application where the schedule is auto triggered everyday but i could see that the application didnt reload for a day and so there is no failure nor the task history .

    Please find the attachment. 

     

    kindly provide help!

     

     

     

     

    Show Less
  • QlikView Creating Analytics

    Export table from QV to Excel

    Hello all,I would like to export two straight tables from QVW to a unique Excel file where the first sheet (respectively the second sheet)  corre... Show More

    Hello all,

    I would like to export two straight tables from QVW to a unique Excel file where the first sheet (respectively the second sheet)  corresponds to the first table (respectively the second table).

    I would like to know if it's possible to export without macro?

    If is not, please could you help me to use the macro from this topic  but without using the "Document Properties set " because this part complicated if I want to share my QVW others users. 

    Thank you in advance for you support.

    Show Less
  • QlikView Scripting

    new values (calculations) depending on hierarchy

    Hello everyone,  I met with a challenge to calculate new values depending on values of subcategory. In original, I have such a tableБВ1... Show More

    Hello everyone, 

     

    I met with a challenge to calculate new values depending on values of subcategory. 

    In original, I have such a table

    БВ1
    1.0А00-Т988900
    2.0А00-В991140
    2.1В16.0-В17.85
    2.2В18.0-В19.9455
    3.0С00-D483500
    3.1D10-D362600

     

    So, here we see that group 1.0 includes values of 2.0 and 3.0, and 2.0 includes 2.1 and 2.2. In the end I would like to get new values of 1.0 (what remains without 2.0 and 3.0), 2.0 (what remains without 2.1 and 2.2) and others, like in the following table: 

    БВ12comment for calculations
    1.0А00-Т98890042608900 - 1140 - 3500
    2.0А00-В9911406801140 - 5 - 455
    2.1В16.0-В17.8555
    2.2В18.0-В19.9455455455
    3.0С00-D4835009003500 - 2600
    3.1D10-D36260026002600

     

    Hope to see your suggestions. 

     

    Thank you! 

    Show Less
  • QlikView App Development

    ADD one more Option in Expression

    Hi Team,I have scenario, Like this.I have 3 List box. Option 1 - Million and Full, When User is selecting Million, Value is coming like 1.1 M, 1.... Show More
    Hi Team,

    I have scenario, Like this.

    I have 3 List box. 

    Option 1 - Million and Full, When User is selecting Million, Value is coming like 1.1 M, 1.45 M and When User is Selecting Full, Value is coming 1000000.45, 1010000 ...... in Straight Table

    Option 2 - No and Yes, When User is selecting No, Some Value is adding and When user is Selecting Yes, Value is extracting in Straight Table

    Both is working well.

    Now I have to add one more option, i.e - Option 3 - 1M, 2M and 3M, Suppose User select the 1M, Now I want only greater than 1M value record in my straight table. 

    Similarly for 2 Million and 3 Million. But my option 1 and option 2 should also work with Option 3.

    Below is my Expression :

    IF(GetFieldSelections(Option1)='Millions', IF(GetFieldSelections(Option2)='No',

    sum({<sub_account={'EXPENSE'}>}Amount)/1000000, (Sum({<sub_account={'EXPENSE'}>}Amount_Ex_CC - Amount_Ex))/1000000),

    IF(GetFieldSelections(Option2)='No', sum({<sub_account={'EXPENSE'}>}Amount),(Sum({<sub_account={'EXPENSE'}>}Amount_Ex_CC - Amount_Ex))))

    This is single expression.

    Can anyone add new option 3 in my above expression.

    Regards,

    AK

    Show Less
  • New to QlikView

    count if value in two columns are the same

    Hi,I have a hierarchy data set and there are cases where parent level and child level are sharing the same value.There are two things that I want to d... Show More

    Hi,

    I have a hierarchy data set and there are cases where parent level and child level are sharing the same value.

    There are two things that I want to do with that.

    1. count the number of rows that share the same value for PARENT  and CHILD

    2. actually filtering for those rows so that I can bring them in to excel file.

    for the first question I was thinking about writing something like

    count( distinct if ( PARENT = CHILD), PARENT)

    but it does not seem to work.

    and for the second one I have no clue at the moment.

    Please help!

    Thank you!

    Show Less
  • QlikView Scripting

    how to create a batch to clean or delete the .Tshared file

    The dashboard using Input field , so the .Tshared file will become larger and larger by time. So we plan to create a batch job to delete or clean the ... Show More
    The dashboard using Input field , so the .Tshared file will become larger and larger by time. So we plan to create a batch job to delete or clean the .Tshared file in qlikview server . Could anyone let me how to do that . Show Less
  • QlikView App Development

    count difference between the reload and after opening the QVW file

    Hi All,Thanks for your time, i have this strange problem - i have a QVW file with few metrics - I reload the data from the QVD filesthen count for one... Show More

    Hi All,

    Thanks for your time, i have this strange problem - i have a QVW file with few metrics - I reload the data from the QVD files

    then count for one of the metric is 181,657 then i save the QVW file and close it. When I reopen the QVW file the count i see is like 76,000 - any one seen this behavior QV12 - what could be the reason

    please, i really appreciate your time

    Show Less
  • QlikView App Development

    Calculating %

    Hi all, I have a calculated field called [Score out of 6] to identify the score of employees.Now i want to calculate Total %ge by team that met a scor... Show More

    Hi all,

    I have a calculated field called [Score out of 6] to identify the score of employees.Now i want to calculate Total %ge by team that met a score of 4 or more. Example: team 1 has 10 employees in Week 10 of 2019. Of these 10 employees, 4 received a score of 4 or higher. The calculated metric for team 1 should be 40%.

    Any help is highly appreciated.

     

    Regards,

    Joshua.

    Show Less
  • QlikView App Development

    Applying a list box to multiple alternate states

    Hello, I have a pivot table that has 3 columns - each with a different alternate state.  I want to filter the results in all 3 columns further, u... Show More

    Hello, I have a pivot table that has 3 columns - each with a different alternate state.  I want to filter the results in all 3 columns further, using a list box, but I don't know how to apply a listbox to all 3 alternate states. I would appreciate any help on this.

     

    Thanks, Sean

    Show Less
  • QlikView Management

    Server files

    Do they know something about to get server information, for example, windows user group/ users/Files  etc, most important for me is... what group... Show More

    Do they know something about to get server information, for example, windows user group/ users/Files  etc, most important for me is... what group of windows does a file belong to?

    Show Less
  • QlikView App Development

    How to Show zero values on Line Chart

    Hi Community.I have a weird one where I have a combo line/bar chart and table where in the chart itself I would like to show all months for the respec... Show More

    Hi Community.

    I have a weird one where I have a combo line/bar chart and table where in the chart itself I would like to show all months for the respective selection even if the value is zero. Please see chart below:

    Combo Chart.JPG

     

    As you can see in the chart, I am missing February and December because the values are zero. 

    In the chart, I have two lines which represent Total (orange) and Filtered result count (green). Though the green line is showing zero for Jan, Mar and Sep values are zero per filtered selection but you can see from the total line that there is associated counts.

    Under dimensions, I have unchecked Suppress When Values are Null. When I check Show all Values, it ignores my year filter and I dont want that. 

    Under Presentation, I have Unchecked Suppress Zero Values. I also tried to check/uncheck Zero on bars but hat did not change anything.

    I only have one dimension which is Year Month. 

    Any ideas on how I can get this to work?

    Thanks in advance. 

     

    Show Less
  • QlikView Management

    Server

    Do they know something about to get server information, for example, windows user group/ users etc, most important for me is name windows user group&n... Show More

    Do they know something about to get server information, for example, windows user group/ users etc, most important for me is name windows user group

     

    Thank you!!!!!

    Show Less
  • New to QlikView

    Count values based on other columns too

    I have a list like thisProduct nameraw material nameFinal product batch numberProduct 1Raw material 11Product 1Raw material 21Product 1Raw material 31... Show More

    I have a list like this

    Product nameraw material nameFinal product batch number
    Product 1Raw material 11
    Product 1Raw material 21
    Product 1Raw material 31
    Product 2Raw material 11
    Product 2Raw material 21
    Product 2Raw material 31
    Product 2Raw material 41
    Product 2Raw material 51
    Product 3Raw material 11
    Product 3Raw material 21
    Product 3Raw material 31

    If I use Count (DISTINCT [Final product batch number]), the function will return 1.

    If I use Count ([Final product batch number]), the function returnes 11.

    The corect answer would be 3, because batch 1 is the batch number of the Product, the raw materials were marked with batch 1 just to group it to the coresponding final product batch.

    We have 3 final products with the same batch number, I would need to count them, for every month.

    Please help me to count the batches taking in consideration the Product name too.

    Thanks,

    Nandi

    Show Less
Moderator
Wlad_Masi Support
Christopher_Ilacqua Employee
BrettBleess Support
Sonja_B Support
Nicole_Tamms Employee
Daniele_Purrone Support
ian_wilson Support
Community Browser

Top Resources

View All

Top Participants

View All