• MSSQL Server Query in QlikView

    I have the following SQL Query which i am executing in MSSQL Server Management Studio:   SELECT COUNT(DISTINCT [Script Number]) AS RxCount FROM tblDatawarehouseConsolidatedCleanStage WHERE [Date Dispensed] >=...
    Christopher Chitemerere
    last modified by Christopher Chitemerere
  • Sum, mode, count question

    Trying to count the number of sizes; however, I do not want to include in the count the sizes that doesn't come in a particular size. The image below shows a dress that comes in numeric sizing; however, the count func...
    Karley Etherington
    last modified by Karley Etherington
  • How to seperate two fields from the combination of two dimnsions!

    Hi, I need to make a list box for new & renewals from the data given below. Once I loaded this sample data with reference to  policy_ no & period from date , i need to separate what is new & renewals....
  • Hide column in Pivot table

    Hi All,   I have the below Pivot table where I have generated dates which isn't available in my DB. The row is getting added(in here 10/19/2017) along with a column full of 0's. Is there a way to hide the column...
    Anupama Jagan
    last modified by Anupama Jagan
  • How to Update

    Hi all,     I have  a table with 4 columns only   I don't have any date field in the data   ,   MY requirement is : my data in database update every week Saturday    s...
    sony sing
    last modified by sony sing
  • Derived Field

    I have the following fields and values in my fact table:   MedAidAmt Shortfall 15 2 5 0.50 0 10 0 20   I want to create two fields based on the value of the MedAidAmt at load script level as follows:  ...
    Christopher Chitemerere
    last modified by Christopher Chitemerere
  • database connections

    did any one used other than ODBC and OLEDB driver. is there any driver or not
    manoj kumar
    last modified by manoj kumar
  • Set Analysis -how to display 2 statuses @hired and @is now

    Hi Experts I need help. Scenario is empl ID 5549 hired in 2016  in dept WAREHOUSE now as of Mar 2017 he is in dept SALES STORE1   Requirement is to show his status/dept at the time of hire and where he is ...
    rashid muhammad
    last modified by rashid muhammad
  • Set expression and Input box not working ? Help

    Hi All ,   I have to calculate sales for particular Item ( which has to be selected by user from Input box ) . But both are not working .     I tried same with sector , it worked for both Input box...
    shekar shekhar
    last modified by shekar shekhar
  • 2 Excel spreadsheets with different fields into 1 qvd

    I have seen some conversation around this topic but I cannot wrap my head around it.   Excel file 1   Requests: Load Id, Request#, RequestDescription, Detail Status.....etc   Excel File 2   Lo...
    Judy Shoop
    last modified by Judy Shoop
  • TOP5 Customers based on sales

    I want to display Top5 customers based on sales in straight table by using expression. Only Top5 customers (Based on sales) should display, remaining customers should not display. Please drop the solution here only ...
    Mallikarjun p
    last modified by Mallikarjun p
  • dump variables and expressions and global number set format?

    Enclosed is a simple project but as you can see, certain expressions (fields/columns) are dependent on other expressions.  Is there a way to dump all variables with their definitions and all expressions, with the...
    becki kain
    last modified by becki kain
  • Concatenate 2 tables with different Calendars

    Hello!  I've been trying to figure out  loading 2 tables joining different Fiscal Calendars  using concatenation....The scripts runs well without error but is not showing the other Fiscal Calendar. ...
    Caroline Acosta
    last modified by Caroline Acosta
  • Sum for different months

    Hello everybody! I have this kind of table     Months      Sales January     50 January     60 Fabruary    60 March &...
    Anna Brancati
    last modified by Anna Brancati
  • Number formatting - millions to billions

    Hi everyone,   I'm a beginner Qlikview user and am still struggling with anything past making simple charts and list boxes.   In this case, I have a 'Market Size' KPI text box, with a formula of =sum(Amoun...
    Andrew Houston-Floyd
    last modified by Andrew Houston-Floyd
  • fix (hold) the row order, in a pivot table

    I have this load script so that my vehicles are displayed in a set order and this works fine, until someone click on a Segment, then the segment which was clicked on goes to the bottom of the table.  if I remove ...
    becki kain
    last modified by becki kain
  • Help with Set Analysis

    Hi,   I would like to show new customers in a pivot table. A new customer is one who has not purchased anything(Direct/Indirect) from the company in the past. The concept I use is, if the customer does not have ...
    Sangeetha Shanmugham
    last modified by Sangeetha Shanmugham
  • Dynamic Totaling

    Hello Everyone,   I have a Text Object with the following expression in it: = 'Total AUM' & ' '& Money(Sum(If(epic_issue_type='Epic' and project_name<>'PMO Test' and project_name<>'PMO IM...
    matt parker
    last modified by matt parker
  • Null value showing up using aggr() function

    Hi All,   I have a requirement where in I need to do a YTD calculation. Pasting a snapshot of the dataset below :       CO Number Month Failed Chan...
    Joshua Palani
    last modified by Joshua Palani
  • where clause

    I need to output N where   [alg-stat] is blank and below is my script     Allergens_Data: NoConcatenate load upper([p-code]) as [p-code], //Upper done in products table [p-split1] //Parent product c...
    Mike Dube
    last modified by Mike Dube