• Color By Dimension inside table

    Hi, How Can I paint a cell in a table by dimension ? For example - I What that each "Branch" Background will be painted in a different color... 1-blue, 2-green, etc...   There are more than 4 branches, so ...
    adi mizrahi
    last modified by adi mizrahi
  • How to separate a long number with a dash "-" ?

    Hi, I have two types of values that I want to write differently, Numbers with 7 digits and Numbers with 8 digits.   For example: Numbers with 7 : 1234567 I want him to be 12-345-67 Numbers with 8 : 12345678 I...
    adi mizrahi
    last modified by adi mizrahi
  • I have month and year but cannot get Quarter

    Hi All, Below script from fourm people here work fine :- SubField([Opportunities Expected Close Date],'-' ,3) as Year, Num(Month(Date#([Opportunities Expected Close Date], 'MM-DD-YYYY'))) as Month,   ...
    Yeo Poh sai
    last modified by Yeo Poh sai
  • How to compute the number of day from 2 date ?

    Hi All I have below 2 expression :- Date(Date#([Opportunities Expected Close Date],'MM-DD-YYYY'),'MMM-YYYY') as [YearMth_EC], Date(Date#([Opportunities Created Time],'MM-DD-YYYY hh:mm:ss'),'MMM-YYYY') as [Yea...
    Yeo Poh sai
    last modified by Yeo Poh sai
  • SubField([Created Time],'-' ,3) as Year_CD, How to remove the time ?

    Hi All I have below script :- [Opportunities Created Time] as      [Created Time], it will display the date and time :- 01-02-2018 08:27:20 01-04-2016 03:03:46 01-04-2016 03:09:00...
    Yeo Poh sai
    last modified by Yeo Poh sai
  • How to remove duplicate data in Field

    Hi Experts,   I have a meeting type code is below...   1X1 GRP 3X1 2X1 CCL Lunch Dinner In that data lot of duplicates is there   How to remove the duplicate in a Meeting type code.   Thanks
    nagarjuna reddy
    last modified by nagarjuna reddy
  • QlikView returning a XML line as output for a procedure call, whereas QlikSense returning data perfectly

    I am unable to execute the stored procedure in QV using below line of code. In QlikSense it is getting executed correctly with data. In QlikView it is giving one column with XML version (attached below). It is althoug...
    Ishan Awasthi
    last modified by Ishan Awasthi
  • Gauge will not display the major units on perimeter when change from 6 to 7 parts

    I have a gauge which has 6 Major units. When I change it to 7 major units the major units are no longer displayed around the edge of the gauge. I have other gauges this works just fine on but one gauge is giving me g...
    Craig Leite
    last modified by Craig Leite
  • How to get count in no of meetings based on metting id(Meeting Id have Duplicate)

    Hi Experts...   How to get  No of meetings and Rank  below the my source file   Based on the client we need count of no of meeting?   Meeting Id Event Date Event Type Meeting Type Code Cli...
    nagarjuna reddy
    last modified by nagarjuna reddy
  • Image on text box loads with annoying border

    Hi all,   I have loaded one image into a text box, and the background color is the same RGB as the image. When the object shows, we could note a little border.   Someone have ideas to make this go away? &...
    Leandro Job Neto
    last modified by Leandro Job Neto
  • Link budget with actual

    Struggling with these two tables , should i create another link table or is their a way to concatenate them
    yusuuf rawat
    last modified by yusuuf rawat
  • why my load script last line not work ?

    Hi All I have a field on sales stage the label very long , i like to shorten it :- Replace([Opportunities Sales Stage],' ','_') as [Sales Stage],  Closed_Lost Closed_Won Commitment_to_Buy Initial_...
    Yeo Poh sai
    last modified by Yeo Poh sai
  • Dimension Expression with aggregation grouping

    Hi All,   Hope you guys are doing fantastic. I have a simple requirement. Below is the simple Dimension Expression I want to add it to the 100% stacked Bar chart. Unfortunately, I am not getting the right result...
    vidya sagar malla
    last modified by vidya sagar malla
  • QlikView application should point to new schema tables instead of the data files

    Hi presently our qlikview application is using source data files and new requirement is to use schema table..... data is same but it should fetch from schema tables....
    pradeep kendur
    last modified by pradeep kendur
  • Is possible to connect to Materialised views existing on a database with Qlikview?

    Hi, I want to connect Materialised views in database to an existing qlikview QVW. How should I point to Materialised views instead of Qvd.
    pradeep kendur
    last modified by pradeep kendur
  • Office 365 Excel file how to connect in Qlik View

    I have tried a while browsing for information on the forum and web on how to connect to Office 365 Excel file from Qlik View. But so far no luck to load Excel file in share point from Qlik View or Qlik Sense.   ...
    Anita Berg
    last modified by Anita Berg
  • Qlikview Sharepoint Connectivity

    Hi All,   Facing issue while trying to extract data from sharepoint lists.   Tried using below methods: 1. RPC procedures:      The created link works on browser & generates xml b...
    Yuvraj Killedar
    last modified by Yuvraj Killedar
  • How to plot funnel chart in qlik view ?

    Hi All   Any one how ?
    Yeo Poh sai
    last modified by Yeo Poh sai
  • sorting data

    i Used this script to sort client for each agency and load only the 20 first agence: LOAD distinct     %ID_AGENCE_CTOS_CLIENT as agenc     FROM [C:\Users\90160\Desktop\hautde gamm...
    souad ouertani
    last modified by souad ouertani
  • sorting in load

    Hello, I have a qvd file with a customer list with score and agencies, ID_CLIENT|agence|name|score I want to sort the customer by agency according to the score and only take the first 20 for each agency L...
    souad ouertani
    last modified by souad ouertani