• consecutive leave days

    Please help, I trying to check employees  who took their leave in consecutive days. I have used this expression but its not working. sum(if(START_DATE - Before([LEAVE START DATE])<=1,[Consecutive Days])) &...
    Caswell Motati
    last modified by Caswell Motati
  • Generic holiday mapping

    So, checking out the various holiday discussions, I noticed that holidays are nothing more than a date pattern.  For example, christmas is always the 25th so will always be one of the following   Mon Dec25...
    Mark Perrone
    last modified by Mark Perrone
  • Sorting Order

    Hi Friends   I have created a pivot table in my QV document which is attached herewit. In my pivot tbale I want to sort Dept based on growth rate of 2017. However though Department are sorted in correct way agai...
    UPALI WIJERATNE
    last modified by UPALI WIJERATNE
  • Nested Variables in Set Analysis

    I have an expression which uses a variable in the set analysis. That variable is meant to return a text value of a set analysis function, based on a series of nested variables. This function is working, but the expres...
    Jason Nicholas
    last modified by Jason Nicholas
  • Nested Variables in Set Analysis

    I have an expression which uses a variable in the set analysis. That variable is meant to return a text value of a set analysis function, based on a series of nested variables. This function is working, but the expres...
    Jason Nicholas
    last modified by Jason Nicholas
  • Expression not matching with dimension in bar chart

    Hi All,   I am experiencing something very strange with a bar chart.  I have one expression value that isn't joining up with a dimension but is still part of it. The bar on the right hand side is the val...
    Jarrad Murray
    last modified by Jarrad Murray
  • Do not know how to stop load entire row based on duplicate value in a column

    Hello Sirs ,   How preventing loading of complet row row based on duplicate value in a given column ?           Area Perimeter Coverage Observation Object A1 10 0.9 OB1 SqPla...
    Prahlad Infy
    created by Prahlad Infy
  • Colors from Text box not coming properly when extracted in PDF

    when we are putting text object in report and extracting in PDF colors of text box background shows grains. Any workaround to fix this so that we can see colors exactly as we see it in dashboard?
    Rohan Dhavle
    created by Rohan Dhavle
  • Use a combo chart to display a dynamic target

    Hello everyone,   I have a bar chart which represent on x axis some dates and on y axis some values I have a target for each month. SO i said using a combo chart could be a solution to resolve the problem. ...
    Yann Lessassy
    last modified by Yann Lessassy
  • REST Connection - Dynamic RestConnectorMasterTable

    Hi,   I have run into a brick wall when looping through an API to retrieve results.   This is the generated script for the RestConnectorMasterTable :     RestConnectorMasterTable   RestCon...
    Phil Rees
    created by Phil Rees
  • YTD usage ?

    Hi All ,   I have the below data .   CUSTID GROUP DATE(DD/MM/YYYY) C1 G1 01/01/2017 C2 G2 01/01/2018 C3 G1 01/10/2017 C4 G2 01/10/2018   In one of the chart ,i have to show bydefault YTD values .We ...
    Veeranjaneyulu Pabbineedi
    last modified by Veeranjaneyulu Pabbineedi
  • Customer search function

    Hello,   For a specific case I need something like a "Conditional reverse Customer Search".   In a first step I want to search for a ZIP Code or City and in a second step I want search the Streets within t...
    Claus Klimmer
    last modified by Claus Klimmer
  • Order of projects in employee details

    Hello All,   I have an employee database in which we are capturing previous organisation details also. So, while taking the same, i want to order the organisations that an employee has already work upon. 1. La...
    Shashank Vyas
    last modified by Shashank Vyas
  • Renaming Columns of a Dynamic Table

    Hi.   Im looping through a sql connection that dynamically names certain columns of a table with each pass so each time the 4th, 5th and 6th columns have a different name depending on the contents....   Is...
    Phil Rees
    created by Phil Rees
  • how to calculate percentage by comparing 2 months data

    Hi All,   I am attaching excel file where i need to calculate % Change from Prior month so in excel its calculated using formula but i need same to be implemented in qlikview. Formula in excel   =IFER...
    Amita Jain
    last modified by Amita Jain
  • previous value with condition

    Hello everyone, I need to add in the script a column with the last hourmeter. See the table bellow in excel. The condition should be the same machine and fuel ID:           ...
    samuel lopes
    last modified by samuel lopes
  • MonthName problem

    Hi guyz, Facing a problem with my monthname field (MONTHS).   My requirement is to when activate the sheet this MONTHS field should always be selected < current month.   For ex: if current month is May...
    sayan ghosh
    last modified by sayan ghosh
  • Macro Set still show total on top

    Hi! does anyone know how?
    Marco Antonio Raymundo
    last modified by Marco Antonio Raymundo
  • Displaying two

    Hi All,   I have two tables (I.e. Table 1 and Table 2). Table 1 and Table 2 are associated by the field "Number".   Table 1:   Table 2: Output:     I am trying to combine two tables...
    Varun Reddy
    created by Varun Reddy
  • Help me to add the expression to the straight table?

    Hi All,   Please help me to add the expression to get the percentage of the categories column. This percentage should be the % of the total categories. Example provided below.   Current output   ...
    durga seelam
    last modified by durga seelam