Qlik Community

Welcome to Qlik Community

cancel
Showing results for 
Search instead for 
Did you mean: 
1,975 online

Here you will find Qlik Sense resources, partake in interesting discussions, solve problems and foster relationships with Qlik experts from around the globe.

Thank you for joining us in the QlikView Forum, your home for QlikView answers. Discover insights within your data that can transform your business.

Direct links to other resources within the Qlik ecosystem. We suggest you bookmark this page.

Learn about upcoming Qlik related events, webinars and local meetups.

Join one of our Qlik Community Groups. Anyone can view content in Open Groups, but you must join to participate. Closed Groups require joining in order to view content and participate.

Hear directly from Qlik employees in our nine unique blogs. Check out the new Customer Success Blog!

Find a forum to ask a question or start a discussion.

Discussion Boards and Documents for Qlik Services.

Qlik partners with leading technology companies to develop integrations, extensions, and connectors to the Qlik platform.

Discussion board and documents related to Qlik Associative Big Data Index.

Learn about the Qlik Community. Explore 'How-To' documentation, ask questions, and engage in discussion around the community platform. This will also be the place where, from time to time, we will do some fun things.

Recent Discussions

  • Qlik Sense App Development

    QlikSense Map missing units settings in Measure

    Hi All , In QlikSense Map ,Dimension : Country Colors by Measure : Euro value . I see that instead of (,) for cents i see (.) which gives a different ... Show More

    Hi All ,

     

    In QlikSense Map ,

    Dimension : Country 


    Colors by Measure : Euro value .

     

    I see that instead of (,) for cents i see (.) which gives a different meaning .

     

    I try to change the settings (like euro denomination ) i dont see it .Any idea to overcome this ?

     

     

    Regards,

    Uma

    Show Less
  • QlikView App Development

    QlikView hangs after Macro

    Good day,I would like to modify a macro to send a straight table data to a excel file rather than a csv file. The original, csv export has been workin... Show More

    Good day,
    I would like to modify a macro to send a straight table data to a excel file rather than a csv file. The original, csv export has been working for a few years from what I can see.
    In the below macro, the portion of the macro that creates the excel file in the correct folder works perfectly.

    The problem comes in when I want to Quit QlikView (ActiveDocument.GetApplication.Quit). When I un-comment that statement and run the macro, the excel file is created but then QlikView hangs with the below error.
    I appreciate your assistance with this. Thank you in advance.

    sub Reorder_Report

    'Reading the file save path:
    set v = ActiveDocument.Variables("vPath")
    vPath = v.GetContent.String

    'Define the file name:
    set v = ActiveDocument.Variables("vFileName")
    vFileName = v.GetContent.String

    'Add the reload timestamp:
    SET v = ActiveDocument.Variables("vfiledate")
    varDate = v.GetContent.STRING

    'Initialize Excel object:
    set XLApp = CreateObject("Excel.Application")

    XLApp.Visible = true

    'Add a Workbook to Excel file:
    set XLDoc = XLApp.Workbooks.Add

    set XLSheet = XLDoc.Worksheets(1)
    XLSheet.Activate

    set table=ActiveDocument.GetSheetObject("CH04")

    'Copy content of this object:
    table.CopyTableToClipboard true

    'And paste into Excel
    XLSheet.Paste

    XLSheet.Name = "Re-Order Report"

    set XLSheet = XLDoc.Worksheets(1)
    XLSheet.Activate

    'Define a Range for which formatting will happen
    set TitleRange = XLSheet.Range("A1:P1")
    TitleRange.Font.Size = 12
    TitleRange.RowHeight = 20

    set DataRange = XLSheet.Range("A2:P300")
    DataRange.Font.Size = 10
    DataRange.RowHeight = 15

    Const xlCenter = -4108
    TitleRange.HorizontalAlignment = xlCenter
    TitleRange.VerticalAlignment = xlCenter

    XLSheet.Range("A1").Select

    XLDoc.SaveAs vPath+vFileName+varDate

    XLDoc.close

    XLApp.Quit

    ' Up to here the xlsx file is created in the folder
    ' As soon as I un-comment the below Quit, QV hangs.


    ' ActiveDocument.GetApplication.Quit

    end sub

     

    Error.PNG

    Show Less
  • QlikView App Development

    Freeze panes

    Hi all,Which is the best object for creating freeze panes ? I am using straight table but my selection functionality is not working properly.For Ex:id... Show More

    Hi all,

    Which is the best object for creating freeze panes ? I am using straight table but my selection functionality is not working properly.

    For Ex:

    id .   name .      country .     ship to

    23    rob            us                23456

    23    bob            ca               23456

    24    jack           us                4560

    here is what i am doing

    i want freeze only 1st field so i have given that field in dimension and remaining fields in expression ,but when i am selecting 23456(ship to) it should show 2 rows right but it is just showing the row in which ship to is selected i.e means 1st row .

    Can any one help to figure this out?

    Thanks in advance

    Show Less
  • Qlik Sense App Development

    master dimension

    i would like to create a master dimension that is a list of customers excluding customers with the last name 'SHOPPER'.what expression should i use?th... Show More

    i would like to create a master dimension that is a list of customers excluding customers with the last name 'SHOPPER'.

    what expression should i use?

    thanks.

     

    john doub

    Show Less
  • New to QlikView

    Sorting Based - ONLY - value

    Hi Community,I have a data like below from there I need values only if Seq is 1,2,3,4,5, not others. In the below example this seq is 2 times only . S... Show More

    Hi Community,

    I have a data like below from there I need values only if Seq is 1,2,3,4,5, not others. In the below example this seq is 2 times only .

     

    SeqValueOriginalSeq
    1101
    2152
    3203
    4254
    5305
    5356
    6407
    7458
    1509
    25510
    36011
    46512
    17013
    27514
    38015
    48516
    59017
    Show Less
  • New to QlikView

    INVALID EXPRESSION , IF script function

    Hi, Why the following  SCRITP code is FAILING in this "IF" FUNCTION,  IF(Action='Action1',SUM(SALES_CONVERTED)) as Sales_converted_Action1ERROR:  Inva... Show More

    Hi,

     

    Why the following  SCRITP code is FAILING in this "IF" FUNCTION,

     

     IF(Action='Action1',SUM(SALES_CONVERTED)) as Sales_converted_Action1

    ERROR:  Invalidad Expression

    That IF function is located at the bottom.

     

     

    Conversion_rates_mapping:
    Mapping LOAD
     Action, 
     Conver_rate
     FROM [lib://TEST APP/Conversion_rates.xlsx]
    (ooxml, embedded labels, table is CONVERSION_RATES);
    
    
    [DATE_PRODUCTION]:
    LOAD
        "Date",
        Action,
        Production,
        Production  *ApplyMap('Conversion_rates_mapping', Action) as SALES_CONVERTED
     FROM [lib://TEST APP/Conversion_rates.xlsx]
    (ooxml, embedded labels, table is DATE_PRODUCTION);
    
    
    [DATE_PRODUCTION_3]:
    NoConcatenate
    LOAD 
        "Date",
        IF(Action='Action1',SUM(SALES_CONVERTED)) as Sales_converted_Action1
        Conversion_rates_mapping:
    Mapping LOAD
     Action, 
     Conver_rate
     FROM [lib://TEST APP/Conversion_rates.xlsx]
    (ooxml, embedded labels, table is CONVERSION_RATES);
    
    
    [DATE_PRODUCTION]:
    LOAD
        "Date",
        Action,
        Production,
        Production  *ApplyMap('Conversion_rates_mapping', Action) as SALES_CONVERTED
     FROM [lib://TEST APP/Conversion_rates.xlsx]
    (ooxml, embedded labels, table is DATE_PRODUCTION);
    
    
    [DATE_PRODUCTION_3]:
    NoConcatenate
    LOAD 
        "Date",
        IF(Action='Action1',SUM(SALES_CONVERTED)) as Sales_converted_Action1
       
    Resident [DATE_PRODUCTION];
    Resident [DATE_PRODUCTION];

     

     

    Show Less
  • QlikView App Development

    Display year wise static value across fields in Pivot table

    We have year wise Contract Share% for 2018,2019. How to display the constant Contract Share % per year across the dimensions and KPIs in a pivot table... Show More

    We have year wise Contract Share% for 2018,2019. How to display the constant Contract Share % per year across the dimensions and KPIs in a pivot table 

    Contract Share comes from an inline table in below format.. 

    Share_DateShare_YearShare_MonthPlantCarrierContract Share (%)

     

    and key has been created Share_Year&'_'&Share_Month&'_'&upper(Plant) &'_'& upper(Carrier) as %Key_ContractShare,

    To Map the key in KPI table  i.e. Year([Ship Date])&'_'&Month([Ship Date])&'_'& upper(Plant) &'_'& upper(Carrier) as %Key_ContractShare,

     

    Below is the screenshot which is showing wrong values for Contract Share %. Need help in correcting

    contract.PNG

    The actual Contract shares are below

      2019
    CatalaoATRHOL50
    CatalaoDICANALLI10
    CatalaoDOLVITSCH10
    CatalaoGEFCO5
    CatalaoRODOMEU5
    CatalaoSHOCK10
    CatalaoTME10
    Show Less
  • QlikView App Development

    Qty Variance analysis in Pivot table

    Dear Experts ,Please help me variance calculation for Fiscal year / Fiscal Qtr / Fiscal month wise dynamically for selected two year.Test data and my ... Show More

    Dear Experts ,

    Please help me variance calculation for Fiscal year / Fiscal Qtr / Fiscal month wise dynamically for selected two year.

    Test data and my QVW is attached for your reference. 

    Thanks a ton.

    Best Regards,

    Milind.

     

     

     

     

    Show Less
  • New to Qlik Sense

    Is there a way to access an app from a stream without clicking login first? (Onl...

     Currently we have an app in a stream called "GROUP-A" and we have enabled access to ONLY 5 users to this stream.Can these users go directly to the fi... Show More
     

    Currently we have an app in a stream called "GROUP-A" and we have enabled access to ONLY 5 users to this stream.

    Can these users go directly to the first sheet of this app if they bookmark the page? Currently if our users click on the direct link, they get access denied. But if they click login and then go to the stream and then open app, they can view the app. 

    Is this possible?

    Show Less
  • New to QlikView

    How to add calculation in expression that based on the value from dimension fiel...

    Hi AllHow can I use the formula you giving in form of table.Calc1 = Billed Revenue in Close Month [Jun only] / Total Billed Revenue of entire month [J... Show More

    Hi All

    How can I use the formula you giving in form of table.

    Calc1 = Billed Revenue in Close Month [Jun only] / Total Billed Revenue of entire month [Jan-Dec]

    I want to make 

    | Month | Calc1 |

    | May       | 0.289 |

    | June     | 0.301 |

    im using expression below but the calc1 shows 0 and not showing any dimension in table.

     

    Expression: 

    sum ({< OppForecast= {'1'},[SPM Close Month] = {'$(=Month([SPM Date]))'}>}[Est. Billed Revenue For Current Year])/ sum ({< OppForecast= {'1'},>}[Est. Billed Revenue For Current Year])

     

    Dimension:

    =Date([SPM Date],'MMM-YY')

    Show Less

Blogs

Qlik Community Manager Blog

Hear from the Qlik Community team about the latest platform enhancements for October and November 2019.

Blogs

Qlik Support Updates Blog

Read the latest blogs from Qlik Support and get important and useful support information.

Blogs

Blogs

Hear directly from Qlik employees and stay current on the latest and greatest information about Qlik products.

Groups

Join a Group

Join one of our Qlik Community user groups around an Industry, Location & Language, or Topic.

Groups

Qlik Deployment Framework

This group hosts information related to the Qlik Deployment Framework (QDF).

2700+ Members

Groups

Qlik Healthcare

This group is for healthcare organizations, partners, and Qlik healthcare staff to collaborate and share insights.

750+ Members

Events

Qlik World 2020

Get the most value from your data and see the hottest trends in data and analytics. Join us in Phoenix, AZ. Register by December 31 to save $400.

May 11- 14, 2020 Conference

Events

Events & Meetups

Participate in an upcoming local Qlik Meetup


Events

Data Revolution Virtual Forum

An exclusive online event where industry experts share practical advice to help your entire team take charge of their data.

Find a location December 3, 4 and 5th