Qlik Community

Welcome to Qlik Community

cancel
Showing results for 
Search instead for 
Did you mean: 
logo
912 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 QlikView

    Linear expression from a specific date

    Hello guys!First of all, I would like to thanks everybody here who is helping me a lot. I'm learning too much here, and I believe I'm working with Qli... Show More

    Hello guys!

    First of all, I would like to thanks everybody here who is helping me a lot. I'm learning too much here, and I believe I'm working with QlikView 12 horas a day, for more than a month. This software is amazing!

     

    Now my question is:
    How can I calculate (via expression), the linear trendline, starting from a specific date ('18/03/2020')?

    Look at that:
    Trendline overall.png

    In this case, QlikView is calculating the overall Trendline (based on my dates selection), but I would like to get something like this - see below:

     

    4.png

     

    I'm currently working with the following expression, but I'm not getting the correct result:

     

    if( DVPG > '18/03/2020',
    	linest_m(total aggr(if(sum(VDAF) ,sum(VDAF)), DVPG), DVPG)
    	* only(DVPG) + linest_b(total aggr(if(sum(VDAF) ,sum(VDAF)), DVPG), DVPG)
    )

     

     

    This is the chart I'm getting, and obviouly it's correct:
    result.png

     

    The Date field is called DVPG, and the Y axis field is called VDAF.

    How can I do that?
    Thanks

    Show Less
  • forum
    New to QlikView

    Divide the current value by the next one on a row (Script)

    Hello guys,How can I create a Script that divides the current value by the next row's value, as you can see below:INDXDVPGVDIFDIFGGBR429/05/2020R$ 13,... Show More

    Hello guys,

    How can I create a Script that divides the current value by the next row's value, as you can see below:

    INDXDVPGVDIFDIF
    GGBR429/05/2020R$ 13,430,992609
    GGBR428/05/2020R$ 13,531,020362
    GGBR427/05/2020R$ 13,261,109623
    GGBR426/05/2020R$ 11,950,966828
    GGBR425/05/2020R$ 12,361,065517

    ...

    ITUB429/05/2020R$ 13,430,992609
    ITUB428/05/2020R$ 13,531,020362
    ITUB427/05/2020R$ 13,261,109623
    ITUB426/05/2020R$ 11,950,966828
    ITUB425/05/2020R$ 12,361,065517


    I have lots of INDXs, so, for each INDX, I want to calculate the DIF.

    As you can see, I want to create the column DIF that is row #1 / row #2. 
    Example: 13.43/13.53 = 0.992609

    This is the script where you can find my code:

     

     

    For each Index in 'BRL=X', 'EURBRL=X', 'CL=F', 'GC=F', 'SI=F', 'BTC-USD', '^BVSP'
    	Add
    	Indices:
    	Load
    		Date(Date#(@1,'YYYY-MM-DD'), 'DD/MM/YYYY')	 				as DVPG,	// Data a ser considerada						 
    		'$(Index)' 													as INDX,	// Índice
    	    Num#(@2, '#,##0,00;-#,##0.00', '.', ',')					as VDIA, 	// Valor do índice na abertura
    	    Num#(@3, '#,##0,00;-#,##0.00', '.', ',')					as VMAI, 	// Valor mais alto do índiceno dia
    	    Num#(@4, '#,##0,00;-#,##0.00', '.', ',')					as VMBI, 	// Valor mais baixo do índice no dia
    	    Num#(@5, '#,##0,00;-#,##0.00', '.', ',')					as VDIF, 	// Valor do índice no fechamento
    	    Num#(@6, '#,##0,00;-#,##0.00', '.', ',')					as VIFA, 	// Valor do índice no fechamento ajustado
    	    Num#(@7, '#,##0,00;-#,##0.00', '.', ',')					as VDIN		// Volume negociado do índice
    	FROM
    		[https://query1.finance.yahoo.com/v7/finance/download/$(Index)?period1=1431043200&period2=1593907200&interval=1d&events=history] 	//5 Years Period
    		(txt, codepage is 1252, no labels, delimiter is ',', msq, filters(
    		Remove(Row, Pos(Top, 1)),
    		Remove(Row, RowCnd(CellValue, 2, StrCnd(contain, 'null')))
    	));
    
    Next Index

     

     

     

    How can I do that?
    I want to do it by Script

     

    Thank you so much!

    Show Less
  • forum
    QlikView App Development

    How can I go to specific line of the code in Qlik Script

    Hi All,How can I go to specific line of the code in Qlik Script. Suppose If we have QVD generator which will create multiple qvd's with in QVW file in... Show More

    Hi All,

    How can I go to specific line of the code in Qlik Script. Suppose If we have QVD generator which will create multiple qvd's with in QVW file in different tabs. So if we want to go to specific tab and execute the script from the there.I don't want to execute all the sheets.As I can not comment each tab and execute the script. 

    Show Less
  • forum
    New to QlikView

    2 Total

    Hi All , Please find the attachment of the excel sheet , I want to show subtotal and Total  in a table in QlikView . I have Department and Category an... Show More

    Hi All , 

    Please find the attachment of the excel sheet , 

    I want to show subtotal and Total  in a table in QlikView . 

    I have Department and Category and Sales , 

    As shown in the screenshot below is it possible to achive this in Qlikview ? 

    smilingjohn_1-1590755821066.png

     

    Thanks in Advcance 

    Show Less
  • forum
    New to Qlik Sense

    Straight table as data source for analysis

    Hi,What currently i have1) Qlik Sense app with data loaded2) Straight table created with complex set of formulas - 4 to 5 fields are calculated. Gener... Show More

    Hi,

    What currently i have

    1) Qlik Sense app with data loaded

    2) Straight table created with complex set of formulas - 4 to 5 fields are calculated. General structure table is as follow

    ID, Date, Measure 1, Measure 2, New Measure 3 (Measure 1 / Measure 4), Category of Measure 3 (Q1, Q2, Q3, Q4 and Q5 based on value), Measure 4, Measure 5, New Measure 6 (Measure 4/ Measure5) 

    My requirement is to have a  separate analysis on this straight table by  another set of complex set of formulas on the all calculated measures.

    All my calculations are dynamic based on many filters.

    Not sure if this is possible.

    Show Less
  • forum
    New to QlikView

    Change accordingly

    Hi tresesco    Vegarsunny_talwari have  table   with below columnsTable1:Region, Month,product ,AmountTable2:Geography,FiscalMonth,Item,SalesSO now i ... Show More

    Hi 

     

     

    Show Less
  • forum
    New to Qlik Sense

    How to handle Date columns which cannot be interpret as those in Qlik Analysis

    Hello!I have following example  table. Its just an cutout of a very big database:Month.Year Sales01.2020 10001.2020 10001.2020 10001.2020 10002.2020 2... Show More

    Hello!

    I have following example  table. Its just an cutout of a very big database:

    Month.Year Sales
    01.2020 100
    01.2020 100
    01.2020 100
    01.2020 100
    02.2020 200
    02.2020 200
    02.2020 200
    02.2020 300
    03.2020 400
    03.2020 400
    03.2020 400
    03.2020 400

    I already got so much help from many here, about how to set the format right. For example Date(Date#()) function and so forth. Its simply not working out for me. I get other problems when I set it manually to a date 'MM.YYYY' format or problems with loading the column at the script with a date related function. 

    So I  try it to take the column now as a number: I guess for Qlik its just a general number Column. Since its not a "date column" I cannot use Date function relate to the time of today for example in my set expressions and if-functions.

    I want to express the following in an KPI window: Always show me the Sales Value (no sum, just whats in the field respective to the month) of todays month. 

    So as an example: In January please return 100, If today would be a day in February please return 200, and when we are in March 400 and so forth....always the actual month we no are at. 

    My problem is following: how Qliksense actually interpret an format like 01.2020? when we get to 2021, will Qlik get the difference between 01.2020 and 01.2021? If  for instance it doesn't interpret 04.2021 (since its next year and also later in the timeline) bigger than 12.2020 I have a big problem using Min/Max Functions.

    Can someone write me a set analysist  expression, a IF-Function or anything else which solve my problem?

    Thanks a lot in advance!

    Show Less
  • forum
    Qlik Sense App Development

    Help Me to get Horizontal filter pane or List Box to directly select values

    Hi guys,Please Help Me to get  Free Horizontal list box or filter pane extension which is working,Need a Filter pane which shows the values in horizon... Show More

    Hi guys,

    Please Help Me to get  Free Horizontal list box or filter pane extension which is working,

    Need a Filter pane which shows the values in horizontal without a dropdown option 

    Show Less
  • forum
    New to Qlik Sense

    No Set expression in If-functions?

    Hello,I found the following information on the qlik help site: The powerful thing of a Set Analysis is the endless possibility of combination dimensio... Show More

    Hello,

    I found the following information on the qlik help site: 

    King88_0-1590864190672.png

    The powerful thing of a Set Analysis is the endless possibility of combination dimensions and even function with Dollar Expansion. 

    For instance if I want to show a KPI windows with the CURRENT monthly sales there are plenty of option to do so with Today() function.

    How to use these in If-Statements. Dollar expansion needed? 

    I know we can put if-statements in Set expression, but how to manage other way round?

     

    Can you please provide examples?

    Thanks in advance!

    Best

    Show Less
  • forum
    Qlik Sense Integration, Extensions, & APIs

    Extension won't work in Qlik Sense Desktop app

    Hi everyone! I'm trying to learn to build my own visualization extensions. The problem I'm having is that the extension I created works well if I run ... Show More

    Hi everyone! 

    I'm trying to learn to build my own visualization extensions. 

    The problem I'm having is that the extension I created works well if I run the dashboard from the localhost server, but it turns into a blank sheet if I try to open it with the Qlik Sense Desktop App. 

    Could you please give me a hint concerning what might cause the problem? 

    The zipped Extensions folder is attached 

     

    Show Less

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