Qlik Community

Welcome to Qlik Community

cancel
Showing results for 
Search instead for 
Did you mean: 
2,545 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.

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 eight unique blogs. Check out the new Architecture Deep Dive 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.


Make Your Data Dance - Virtual Forum 2019

You’re managing more data than ever before. But are you getting the insights you need? The Qlik Virtual Forum is here to help you take control and make your data dance.

Recent Discussions

  • New to QlikView

    Count if Substring/Number True

    In My below expression for chart , i need to count the column "c_code" only if the first digit is a 3 , please help me with the syntax. The column has... Show More

    In My below expression for chart , i need to count the column "c_code" only if the first digit is a 3 , please help me with the syntax. The column has values such as "321" or "3-2-1" 

    =Count({<left(C_code,1)={$(3)}>}[C_code])

    Show Less
  • Qlik Sense Cloud Discussions

    Refreshing Applications in Qlik Sense Cloud

    I have an application in Qlik Sense Cloud that is loading data from a couple of Excel files. These files are continuously updated with new transaction... Show More

    I have an application in Qlik Sense Cloud that is loading data from a couple of Excel files. These files are continuously updated with new transactions and I would like to refresh the Qlik app on a daily or weekly basis.

    What is the easiest way to set this up? I am quite new to the Cloud version of Qlik sense and how publishing and reloading works. I am currently using the Free version so perhaps I am restricted to a semi-manual procedure.

    Any help is appreciated!

    Show Less
  • QlikView Layout & Visualizations

    URL to a specific dashboard on Accesspoint

    Hello,We have around 10 dashboards on our accesspoint. I want to give users a link to specific dashboard instead of them going to accesspoint and sele... Show More

    Hello,

    We have around 10 dashboards on our accesspoint. I want to give users a link to specific dashboard instead of them going to accesspoint and selecting the dashboard.

    Is there a way to give Accesspoint URL to user so that he/she can directly open a specific dashboard from those 10 dashboards?

     

    Thank you!

    Show Less
  • QlikView App Development

    Total YTD Sales of top N customers by YTD sales

    Hello All , I have the below expression to calculate the Total YTD Sales for top N Customers   but the expression is is returing 0 when... Show More

    Hello All ,

     

    I have the below expression to calculate the Total YTD Sales for top N Customers   but the expression is is returing 0 when the current month sales is Zero.

     

    =Sum(Aggr(If(Rank($(eActualValueYTDRank)) <= $(vHospRank), $(eActualValueYTDRank)),ListHosp_Ranking))

    Any insights on the issue is welecome.

     

    Thanks

    Kusha

    Show Less
  • QlikView App Development

    How do I set same colors for the same codes all over the model ?

    hi , in my qv model i have classes , and for each there is a unique code .by selection - its possible that the relevant code will be :10,98,111,112,32... Show More

    hi , in my qv model i have classes , and for each there is a unique code .

    by selection - its possible that the relevant code will be :

    10,98,111,112,320 ..   or 10,11,34,320,441,501 ..    or 11,12,13,111,112,113,333,444 ..

    the thing is that i need to set same colors for the same codes all over the model - at all tabs , all objects  ,

    so the first code - no matter the value is - will be green, the socond will be red , the third blue ,  and so on ....

    ( according to the colors - Data Apearance palate  )

    How can I do this in the simplest way?    THANS.

    Show Less
  • Qlik Sense App Development

    Based on Level of a hierarchy, display a specific column

    HiI have a drill in a qlik sense app -  I am able to identify what level i am at in the drill (=GetObjectField(0)), but based on that i want to b... Show More

    Hi

    I have a drill in a qlik sense app -  I am able to identify what level i am at in the drill (=GetObjectField(0)), but based on that i want to be able to output a specific field.

    I have tried all the options i can think of!

    =if(GetObjectField(0) = 'Hierarchy2' , 'Correct level', 'Not at this level') - this returns  'Correct level'

    =if(GetObjectField(0) = 'Hierarchy2' , [H2_DriverName], 'Not at this level')- this returns  'Not at this level' 

    So in the example below the required output would be whatever is in H2_DriverName.  If the user drills further it would go to H3, H4 etc.

    Cheers!

    Hierarchy2=GetObjectField(0)Required OutputH2_DriverNameH3_DriverNameH4_DriverName
    Com AAHierarchy2OblongOblongRectangleCheese
    GR BBHierarchy2CircleCircleBananaLemon

     

    Show Less
  • New to Qlik Sense

    storing the value of summission of a column in variable

    Table A:ColumnName1,colmnName2a                    ... Show More

    Table A:

    ColumnName1,colmnName2

    a                                   2

    b                                  3

    c                                  4

    vVariable1=sum(columnName2) where columnName1=(a and b) i.e. vVariable1=5

    i want sum (columnName2) with where condition(columnName2=a and b) and store into an variable vVariable1.

     

    Show Less
  • QlikView Scripting

    Adding a new column with Field value from same table

    I would need to add one extra column to my table of X-rates, simply using one of the values in the table (EUR per USD xrate) and populate this value a... Show More

    I would need to add one extra column to my table of X-rates, simply using one of the values in the table (EUR per USD xrate) and populate this value across all rows in my table. I thought it would be easy , but I can´t find the way to do it. 

    Any help is appreciated. Here is the piece of code I am struggling with 

    Directory;
    LOAD
    Country,
    CURRENCY,
    CODE,
    USDperCURR,
    CURRperUSD,
    if(CODE='EUR',CURRperUSD) as EURperUSD
    FROM 201906_MOR.xls (biff, embedded labels, table is Summary$, filters( .......));

    I simply need the last calculated field to populate for all rows ...not only for the row where CODE=EUR ( like in attached printscreen ).

    Thank you !!

    Show Less
  • New to QlikView

    White table in table viewer issue

    Hi All, I am unable to view/see my tables in table viewer. Please find attached screenshot All the table are showing as white and if I expor... Show More

    Hi All,

     

    I am unable to view/see my tables in table viewer. Please find attached screenshot

     

    WhiteTableViewer.PNG

    All the table are showing as white and if I export or copy then it is showing me table correct.

     

    Kindly help.

    Regards,

    Mahamed

    Show Less
  • Qlik Sense Cloud Discussions

    Qlik Sense Cloud Extension - Reload Button

    Hello,It is possible to use Extension Reload Button in Qlik Sense Cloud- Business?If not, what is the alternative to be able to reload (update) the da... Show More

    Hello,

    It is possible to use Extension Reload Button in Qlik Sense Cloud- Business?

    If not, what is the alternative to be able to reload (update) the data? Besides the alternative to access "Data load editor". Perhaps, the data reload when I press "refresh" to the page? Or not?

    Thank you a lot!

    Show Less

Blogs

Qlik Community Blogs

Check out our community blogs to stay current on the latest and greatest information about Qlik products.

7 Blogs

Groups

Join a Group

Join one of our Qlik Community groups related to an Industry, Location, Language, or Topic.

28 Groups

Events

Events & Meetups

Participate in an upcoming Qlik related event, webinar, or local meetup.