• 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
  • 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
  • How to plot funnel chart in qlik view ?

    Hi All   Any one how ?
    Yeo Poh sai
    last modified by Yeo Poh sai
  • Type Mismatch on copyObjectsToExcelSheet

    i used this script to copy table to excel     Sub export_situation() set val=ActiveDocument.Fields("souad").GetPossibleValues for i=0 to val.Count-1     ActiveDocument.Fields("souad").Select (v...
    souad ouertani
    last modified by souad ouertani
  • How to make field Month_n into list box with 4 selection for filter month ?

    Hi All I have a field month_n if i click 0 , it will select current month. if i click -1 , it will select Next month. if i click -2 , it will select Next 2 month. if i click -9 , it will select Next 9 month...
    Yeo Poh sai
    last modified by Yeo Poh sai
  • How to filter HAKKO customer ?

    Hi Sir I have product field. inside the product field it have data Hakko Hakko/Beckhoff Hakko/Beckhoff/Mitsubishi May i know how to create a new field name "Hakko_User" to list those who customer int...
    Yeo Poh sai
    last modified by Yeo Poh sai
  • 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
  • Does any one ever using qlikview access vtiger 6 ?

    Hi All   I have try to goolgle for the above , but unable find the solution. in case you have ever access vtiger data base , kindly share with me how to do it ?   Paul Yeo
    Yeo Poh sai
    created by Yeo Poh sai
  • How to re-arrange my sales stage sequences for easy view ?

    Hi All, I have sales stage , which have more then 7 label. Now when i plot in stack chart , the sequences does not go with the flow. My sales stage now is like below sequences :- Closed Lost Closed Won Com...
    Yeo Poh sai
    last modified by Yeo Poh sai
  • Why one condition work when add one more condition it return wrong value ?

    Hi All My expression below work fine :- sum(if([Sales Stage]='Sales_Fulfillment',(Amount))) But when i want to add one more condition , it does not give the correct result :- sum(if([Sales Stage]='Closed_...
    Yeo Poh sai
    last modified by Yeo Poh sai
  • Constante entière attendue with VB qlikview

    Hello Ihave i straight table and list selection (Agence),  So i need for every selection value export the table to excel sheet for example   agence 01 agence 02 agence 03   i need to have in my excel fi...
    souad ouertani
    created by souad ouertani
  • export table to excel file

    Hello Ihave i straight table and list selection (Agence),  So i need for every selection value export the table to excel sheet for example   agence 01 agence 02 agence 03   i need to have in my excel fi...
    souad ouertani
    last modified by souad ouertani
  • If condition in Load statement

    Please help me to flag like below in load statement. If date field is null should be flag as 'New'   LOAD * INLINE [     CustID, Max_Sales_Date     2, 2/14/2013    ...
    Kirubakaran Nagaraj
    last modified by Kirubakaran Nagaraj
  • (Pending|Negotiation) Does not able to activate ?

    Hi All I need to create a button , when i activate , i need the Pending & Negotiation label to be turn on. So i using below script :- (Pending|Negotiation) But it does not work. Can some one advise...
    Yeo Poh sai
    last modified by Yeo Poh sai
  • My month_n script is not working ?

    Hi All I have below script work fine :- SubField([Expected Close Date],'-' ,3) as Year, Now i need to create month_n field :- (year(today()) - year(@50:60T)) * 12 + month(today()) - month(@50:60T) + 1...
    Yeo Poh sai
    last modified by Yeo Poh sai
  • How to convert date format DD-MM-YYYY into Year ?

    How to convert date format DD-MM-YYYY into Year ? Hi All I have import a raw data file from Excel to Qli View. I try to convert the imported field name = [Expected Close Date] in order year format YYYY. ...
    Yeo Poh sai
    last modified by Yeo Poh sai
  • How to get no of meeting Based on Client name and unique Meeting Id

    Hii..   my source like below ..      Meeting Id Event Date Event Type Meeting Type Code Client Name Product Line 161967P 1/24/2017 Conference DINNER Anbang Asset Mgmt (Hong Kong) Co Ltd Eco...
    nagarjuna reddy
    created by nagarjuna reddy
  • table merging

    I have a need to multiply a table a by the possible values of a table b, someone help me
    souad ouertani
    last modified by souad ouertani
  • Finding the related expression in a straight table

    I am facing a very strange issue here, I am trying to modify an app that's been developed by someone else that I have no access to. We have a straight table, with some columns that have different calculation methods...
    ar eiuiew
    created by ar eiuiew