Qlik Community

Welcome to Qlik Community

cancel
Showing results for 
Search instead for 
Did you mean: 
logo
1,399 online
Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now

Find the forums for your Qlik data analytics products to ask a question, start a discussion, or review documentation.

Find the forums for your Qlik Data Integration products to ask a question, start a discussion, or review documentation.

This forum will provide you with event highlights and related content to get you energized and ready for QlikWorld 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.

Participate in Qlik Technical Previews, submit ideas, and review documentation.

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 ten unique blogs. Check out the new Product Insight & Ideas Blog!

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

Discussion Boards and Documents for Qlik Services.

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.

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

Recent Discussions

  • No Boards Found
  • forum
    New to Qlik Sense

    How to hide ' Total ' text and and respective of ' zero' value in Pie Chart Qli...

    Hi,As per requirement, we enabled ' Total ' in appearance of Pie chart and kept it in middle of the pie chart.Which is showing the values according to... Show More

    Hi,

    As per requirement, we enabled ' Total ' in appearance of Pie chart and kept it in middle of the pie chart.

    Which is showing the values according to filter selections but we dont want to show the 'total' text and respective of 'zero' values according to filter selections.

    Request you to kindly let me know the solution and help me out on this.

    thank you in advance.

     

    Regards,

    Vara

     

    Show Less
  • forum
    QlikView App Development

    Auto Scaling in Bar graph

    I have a dashboard showing two bar graph, one showing Current period and another showing prior period for a metrics. In the Number tab of chart proper... Show More

    I have a dashboard showing two bar graph, one showing Current period and another showing prior period for a metrics. In the Number tab of chart property, I have given Symbol format as Liters, K liters.. upon selections, the user see scale difference in both charts where Current period has scale of K liters and the Prior period has the scale of Liters. Upon further analysis, I found that the Current period has a values  above 3500 liters and prior period has values below 3500 liters.

    Can someone help me identify how qlikview demarcate the scale change for Liters to K liters to M liters?

    Show Less
  • forum
    New to Qlik Sense

    N-Printing: Colour Conditions not working with Keep Source Format Option in HTML...

    Dear Qlikxperts!!I'm working with June 2019 version of N-Printing. I have created a HTML report and want to bring the content to bodyof the mail which... Show More

    Dear Qlikxperts!!

    I'm working with June 2019 version of N-Printing. I have created a HTML report and want to bring the content to body

    of the mail which is through. However the "Keep Source Format" option isn't working fine. I have provided background colour conditions for table objects which doesn't reflect in N printing output. Kindly share the necessary things to be done.

     

    Also is it possible to create a NPrinting report with Excel format and while publishing insert it in the body of the mail?

    Thank You!!

     

    Show Less
  • forum
    Community Corner

    Creating a Trend

    Hi - What would be the best approach or logic to use if I want to create a trend by adding dimensions to each group. For example:Previous FY - Bar sho... Show More

    Hi - What would be the best approach or logic to use if I want to create a trend by adding dimensions to each group. 

    For example:

    Previous FY - Bar should only reflect "Previous FY" Data only

    FY-2015 - Bar should reflect "Previous FY" + "FY-2015" data to create a trend

    FY-2016 - Bar should reflect "Previous FY" + "FY-2015" + "FY-2016" data to create a trend

    Capture.PNG

    Show Less
  • forum
    New to Qlik Sense

    Qlik sense extension

    Hi Guys,I am new in Qlik sense I want color of text background but there is no option in Qlik cloud  when browse this issue on google I found try to u... Show More

    Hi Guys,

    I am new in Qlik sense I want color of text background but there is no option in Qlik cloud  when browse this issue on google I found try to use Qlik sense extension. Can you please help me how to use Qlik extension how to download how to import it in Qlik sense cloud.

    Show Less
  • forum
    New to QlikView

    Case 881 How to create expression to compute inventory Amount with Latest exchan...

    Hi AllI have below load script working fine :-// Part 1 Load the inventory raw data for SOURCE indonesia  INVENTORY:LOAD'TI' as SOURCE,(@54:60T)*(@61:... Show More

    Hi All

    I have below load script working fine :-

    // Part 1 Load the inventory raw data for SOURCE indonesia  

    INVENTORY:
    LOAD
    'TI' as SOURCE,
    (@54:60T)*(@61:75T) as C_ONHAND_AMT
    From $(vRAWPath)$(vFile263)(ansi, fix, no labels, header is 0, record is line);

    // Part 2 Load the inventory raw data for SOURCE Singapore 

    LOAD left (FileBaseName(), 4) AS TDSS_invc,
    'TS' as SOURCE,
    (@54:64T)*(@65:75T) as C_ONHAND_AMT,
    Date((@286:296T), 'DD-MMM-YYYY') as INVC_DATA_TDSS
    FROM $(vRAWPath)$(vFile253) (ansi, fix, no labels, header is 0, record is line);

    // Part 3 Load the monthly exchange table

    LOAD SOURCE,
    Rate,
    MonthName(date) as [SalesMonth], //Join on to sales table -> Dont change name
    Rate_
    FROM
    Map_Rate_.xlsx
    (ooxml, embedded labels, table is Sheet);

    My Table need expression for compute amount base on latest exchange rate for June 15000.

    I have Try :- Sum(C_ONHAND_AMT)*Rate , it display Null.

    Untitled.png

    My question is how to compute 301,887,280 X 15000 ( 2020 June Exchange Rate )

    My data model :-

    table model.png

    Hope some one can advise me.

    Paul Yeo

    Show Less
  • forum
    Qlik Sense App Development

    Count of quarter.

    Hello all,I have data of 4 year so I want to show data quarter wise .For.eg In 4 year there are 16 quarters , I want quarters in this format shown as ... Show More

    Hello all,

    I have data of 4 year so I want to show data quarter wise .

    For.eg 

    In 4 year there are 16 quarters , I want quarters in this format shown as below :

    Q1, Q2,Q3,Q4,Q5.....Q15,Q16 etc

    Can anyone help me to get quarter in that format I have date field as in  DD-MM-YYYY.

    Highly appreciate for any solution.

     

    Regards,

    Kavita 

     

    Show Less
  • forum
    Qlik NPrinting Discussions

    Qlik Variables in Dynamic File Naming is not working properly in Nprinting Feb 2...

    Hello ,Can someone please help on this. It's a bit urgent.We have installed Qlik Nprinting 20.0.2(February 2020) and Qlikview Desktop 12.40 versions r... Show More

    Hello ,

    Can someone please help on this. It's a bit urgent.

    • We have installed Qlik Nprinting 20.0.2(February 2020) and Qlikview Desktop 12.40 versions respectively.
    • From Nprinting, we are trying to generate the report by enabling Dynamic naming. The expected output report should be in format "ReportName_vMonthYear.xslx" (Example: Report123_May2018.xslx). 
    • Here vMonthYear is the Qlikview variable which has the expression: =GetFieldSelections(Month)&GetFieldSelections(Year)
    • But the actual report that is getting generated is not fetching the Qlik variable vMonthYear value. The output we are getting is Report123_-.xlsx (vMonthYear is coming as "-").
    • The Qlikview variables with GetFieldSelections function is not working in Nprinting.

    And also, We have observed that if the Qlikview variable has Static value (like hard-coded value), then that variable is getting passed to Nprinting and the Qlik variable in dynamic file name is getting generated Properly. But if the Qlikview variable is computed by making use of any Field then that value is not getting passed to Nprinting and the output is coming as "-" in the dynamic file name.

    We have tried various options by creating the new variable in Qlikview and storing this vMonthYear value: 

    • vTest=vMonthYear
    • vTest=$(vMonthYear)
    • vTest='$(vMonthYear)'
    • vTest=$(=vMonthYear)

    and passing this newly created variable (vTest) in Nprinting Dynamic file naming. But nothing worked out.

    If someone has encountered this issue, Please help.

    Thank You.

    Show Less
  • forum
    New to QlikView

    Variation between years

    Dears,How can I calculate the variation of VDAF between years?This is how my Database looks like:Obviously, I have VDAF for each company, every day si... Show More

    Dears,

    How can I calculate the variation of VDAF between years?

    This is how my Database looks like:
    Obviously, I have VDAF for each company, every day since 2015...

    DVPGSTCKVDAF
    31/05/2020AZUL4 R$   98,12
    30/05/2020AZUL4 R$   26,33
    29/05/2020AZUL4 R$   40,33
    13/02/2019AZUL4 R$   58,50
    12/02/2019AZUL4 R$   26,85
    11/02/2019AZUL4 R$     9,24
    08/05/2018AZUL4 R$   29,07
    07/05/2018AZUL4 R$   34,45
    06/05/2018AZUL4 R$   71,39
    31/05/2020GOLL4 R$   86,19
    30/05/2020GOLL4 R$   91,29
    29/05/2020GOLL4 R$   10,04
    13/02/2019GOLL4 R$   57,63
    12/02/2019GOLL4 R$   85,97
    11/02/2019GOLL4 R$   37,59
    08/05/2018GOLL4 R$   72,32
    07/05/2018GOLL4 R$   33,60
    06/05/2018GOLL4 R$   89,95

     

    I would like to obtain something like this:

    Year (DVPG)STCKVV VDAF
    2018AZUL4-59%
    2019AZUL4533%
    2020AZUL4143%
    2018GOLL4-20%
    2019GOLL453%
    2020GOLL4758%

     

    How can I do that?
    Thanks

    Show Less
  • forum
    New to QlikView

    使得科技股放假合适的方式

    技术的广泛空间的公司减肥给浑善达克房间大概数控加工后放声大哭结果合法手段

Top Participants

Blogs

Qlik Community Manager Blog

Hear from the Qlik Community team about the latest platform enhancements for December 2019 and January 2020.

Blogs

Customer Success Blog

Read all about Qlik's Voice of the Customer program and Customer Success initiatives.

Blogs

Blogs

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

Groups

Qlik Insight Bot

Join the Qlik Insight Bot Group and bring the power and simplicity of natural-language, conversational analytics to everyone in your organization

open to all

Groups

QlikView to Qlik Sense

Join the QlikView to Qlik Sense group and help you modernize your BI experience through adoption of Qlik Sense.

open to all

Groups

Qlik Healthcare

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

750+ Members

Events

The Human Impact of Data Literacy

Boosting the data skills of your entire workforce can exponentially increase your data’s value. In this webinar, discover the big opportunity in data literacy.

On Demand Webinar

Events

Events & Meetups

Virtual Meetups are now a possibility! With the impact of COVID-19, the Qlik Meetup network has expanded its support to include the ability to host your next Meetup online. Email QlikMeetups@qlik.com to get your virtual Meetup started!


Events

What's New in 2020?

Join us on for a deep-dive discussion and tailored product demonstration on the newest capabilities delivered as part of Qlik’s most recent product release.

Now Available on Demand