• How to compare current and prior values

    I have a case where I need a label "Decrease" or "Increase" after checking row by row in a pivot table. Below sample, 'Day 3' is my current Data and 'Day 2' is my Prior data for sample purposes. If TheCount in current...
    John Jackson
    last modified by John Jackson
  • User input with scatter plots

    I have a need to create a scatter plot with the following criteria: 1) Date is on the x-axis 2) A test point result from an in-plant data base which is already successfully loaded on the y-axis 3) In the scatter pl...
    walt schwartz
    last modified by walt schwartz
  • Set analysis sur jour suivant

    Bonjour à tous,   je suis en face d'un souci  sur lequel je n'y arrive pas   j'ai besoin de faire une somme sur différent jour : J+1 , J+2, J+3. J'arrive a faire cette somme sur une semai...
    Fabien LAPIERRE
    last modified by Fabien LAPIERRE
  • QlikSense Map

    Hi Team,   I have a requirement , where i need to show some expression values in the tooltip. Currently am not able to achieve it. Am able to show the values only as labels. Is there any alternate solutions t...
    created by SENTHIL K
  • Building a query dynamically based on user selected tables and columns in qlikview

    Hi,      We have a requirement from users wherein the user should be able to select one or more tables (say from a list box) and their associated columns and construct a query with or without a Where c...
    sri vidhya
    last modified by sri vidhya
  • QlikView Date Range Picker

    Hi,   I've followed this guide here: Selecting Arbitrary Date Ranges however when it came to selecting a date, nothing happened. What have I done wrong?   Thanks for any help.
    Ahmed Mohamed
    last modified by Ahmed Mohamed
  • Multiple data calculate distinctly under specific condition

    Hi everyone, I want to extract a value from my database and calculate it distinctly, below just an example: I want to calculate the first time success rate from below table: The condition: no matter finally the bat...
    Kwan Siu
    last modified by Kwan Siu
  • Multi-box question

    I have a multi-box using the field name "Event".  There are 20 values that can be displayed when you click the drop down arrow on the multibox.  I don't want to show all 20 values, I only want to show the va...
    Daniel Rohm
    last modified by Daniel Rohm
  • multi box help

    I have a field, "Patient_Type" that I want to put into my multi box.  The values inside this field are 1, 2, 3.  When a user clicks the drop down of "Patient Type" in the multi box, I want it to display "ER"...
    Daniel Rohm
    last modified by Daniel Rohm
  • Set Analysis aggregate with date range

    Hi community,   I have a set analysis which works fine until I have got one company group selected. If I select more company groups or clear the filter it doesn't show any figures. Just a bit explanation for the...
    Keith Hardy
    last modified by Keith Hardy
  • Set Analysis \ addmonths

    hi all   trying to calculate previous three months from user selection i.e if the user selected 201804 the expression should retrieve calculation for : 201804,201803,201802   tried it with : SUM({<YY...
    ilan baruch
    last modified by ilan baruch
  • Calculated fields with different tables

    Hey people,   I have the follow situation, i want to make a calculated field with different tables. I have one table named BD Chat, with this field named "Chat Date" and another table named Reservations with a f...
    Igor Castelo
    last modified by Igor Castelo
  • Unbold a partial sum

    hi, creating a pivot table, with 4 dimensions, one of which is horizontal. Making a partial sum for all dimensions.   The default is that the partial sum will be bold. Is there a way to avoid that. Please don'...
    Simon Brulotte
    last modified by Simon Brulotte
  • Alt not working for multiple expression

    Hi   I am trying to display past 3 weeks of data , created expressions for each week and using Alt to diplay 1 bar for closed and 1 bar for Created for past 3 weeks.   But for some reason only Max week is ...
    steve jones
    last modified by steve jones
  • Selection on one Dimension should not effect the values of another Dimension and Wise versa.

    Hello All,   When i select a value from  Dimension1,the  other Dimension values are getting faded out... i mean from the below table             1.0_Fiscal Year,2.0_Fis...
    naveen kumar
    last modified by naveen kumar
  • convert multiple excel files into one qvd

    I have multiple excel files that have exact same data structure. the file names follow up the following patter, sales201501.xls sales201502.xls sales201503.xls etc. where the 01, 02, 03 are week number. A new ...
    surfman joe
    last modified by surfman joe
  • How Do I Get the Number of Months Between Two Dates?

    Hi all, I am still lost in number of months between dates expression. Being New to QV & Scripting but is been like thrown into the deep end. this question was raised by @Jonathan Shaltz earlier     D...
    last modified by Tony THOMPSON
  • Color coding in line chart

    Hi, I have a scenario where i am showing week on week Sales in line chart. I want to change the color of line chart symbol as per the below thing: if current week sales amount is less than prev week sales amount then ...
    Nupur Sabnawis
    last modified by Nupur Sabnawis
  • Fractile on list of values

    I create a sorted list of values:   =Concat( [WL-WA], ',',[WL-WA])   which results in: and I want the Fractile 0.05 and 0.95 calculated from this list.   Combining Fractile around the concat is n...
    Michiel van de Goor
    last modified by Michiel van de Goor
  • Set Analysis - numeric date range doesn't work

    Hi Guys,   I am trying to get the total sales figures for certain accounts where their status "expiry date" is lower than the currently selected month. The vCurrentMonthSelection variable is a short date format ...
    Keith Hardy
    last modified by Keith Hardy