Qlik Community

Welcome to Qlik Community

cancel
Showing results for 
Search instead for 
Did you mean: 
logo
1,067 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

    Special characters in a number field

    Hi, I have a field (SMSNo) field where cell numbers are captured in, but i have occasions where people capture  special characters in, i want to creat... Show More

    Hi, 

    I have a field (SMSNo) field where cell numbers are captured in, but i have occasions where people capture  special characters in, i want to created an if statement in my script to identify just the client records  whom has a special character in the (SMSNo) field and where the number does not contain 10 digits. I also want to eliminate the fields that are blank.

    Thank you

     

     

    Show Less
  • forum
    New to QlikView

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

    Hello guys,How can I divide the current value by the next value on a row via Script?Check the following example:INDXDVPGVDIFDIFGGBR429/05/2020R$ 13,43... Show More

    Hello guys,

    How can I divide the current value by the next value on a row via Script?
    Check the following example:

    INDXDVPGVDIFDIF
    GGBR429/05/2020R$ 13,430,992609
    GGBR428/05/2020R$ 13,531,020362
    GGBR427/05/2020R$ 13,261,109623
    ITUB429/05/2020R$ 11,950,966828
    ITUB428/05/2020R$ 12,361,065517
    ITUB427/05/2020R$ 11,600,962656
    GOLL429/05/2020R$ 12,051,010906
    GOLL428/05/2020R$ 11,921,010169
    GOLL427/05/2020R$ 11,800,998308

     

    As you can see above, I have some INDXs, and I want to calculate the DIF:
    DIF = Current value of VDIF / Next value of VDIF 
    Example: 13.43 / 13.53 = 0,992609

    Note that I have some INDXs, so this calculus should consider the INDXs... it's not just dates.

     

    This is my script:

    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

     

    And I would like to do it via script
    How can I do that?

     

    Thanks

    Show Less
  • forum
    New to Qlik Sense

    Qlik Default Join

    I am joining two tables.Lets say for example(Table A, Table B)Table A:A,BTable B:A,CThe result from the above is not matching when I put outer join be... Show More

    I am joining two tables.Lets say for example(Table A, Table B)

    Table A:

    A,B

    Table B:

    A,C

    The result from the above is not matching when I put outer join between these two

    Table A:

    A,B

    outer join(Table A)

    Table B:

    A,C

     

    Ideally both should be same right?

    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 Qlik Sense

    Display a calculated measure based on a higher dimension than that shown in a ta...

    helloprobably the title does not say much, but here is my problem, sorry if it has been posted already by someone elseI have the following data struct... Show More

    hello

    probably the title does not say much, but here is my problem, sorry if it has been posted already by someone else

    I have the following data structure: Client id, Client Region, Salesperson, Sales 

    I need to display Sales calculated at the Region level in a table which only shows a subset of the clients - and this subset is defined by a selection on the Salesperson field

    I could not manage to produce a formula that works in a predictable manner.

    I also tried creating a separate table storing only region and region sales, but for some reason that also does not work correctly... maybe because the connection is via the Region field and not the client field, I don't know.

    a solution is to use an apply map, but it is impractical for me (the data structure is much more complicated and I would have to use a compound key etc) so I was wondering whether a formula exists

    thank you
    LM

    example mock data

    liviumac_1-1590826052393.png

     

     

     



    Show Less
  • forum
    QlikView App Development

    Flag for selected or not selected value in Current Selection Box

    Hi Team,I want to create a flag in QlikView Script, If I select entry_date. Total no. of record in entry_date is 644 and I have selected 401 value. So... Show More

    Hi Team,

    I want to create a flag in QlikView Script, If I select entry_date. Total no. of record in entry_date is 644 and I have selected 401 value. So I need a flag like Y for all those value selected and N means not selected records.

    Hope you got my answer. Can any one help me on this.

    For data related qvw, I am attaching my qvw.

    Regards,
    Sona_SA

    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
    QlikView Scripting

    Filtered Views (MS Dynamics CRM ) in QlikView Dashboard

    I am having trouble in using Filtered Views in the QlikView Dashboard. When i use the Filtered views and run locally dashboard works fine. But, proble... Show More

    I am having trouble in using Filtered Views in the QlikView Dashboard. When i use the Filtered views and run locally dashboard works fine. But, problem occurs when i publish to the QMC & it won't retrieve any results from the view . This problem doesn't occur when i use tables instead of Filtered Views

    For eg.,  Using following table works fine

    LOAD id,

    name

    SQL SELECT *

    FROM Contact (NOLOCK);

     But if i use the following Filtered View, the view doesn't execute & won't retrieve any results after publishing to QMC.

    LOAD id,

    name

    SQL SELECT  *

    FROM FilteredContact (NOLOCK);

    Does anyone has a fix to this or any suggestions on how to handle this ?

     

    Show Less
  • forum
    New to Qlik Sense

    How to avoid incompleted week data to display

    Hi,I have day field which is no. of days from starting onwards in my data like 1,2,3,...Here to get the no. of weeks divided the day with 7  and by us... Show More

    Hi,

    I have day field which is no. of days from starting onwards in my data like 1,2,3,...

    Here to get the no. of weeks divided the day with 7  and by using ceil i got but it displays week even for incomplete weeks  how to avoid those 

    ex.

    field have 1 to 16

    how to avoid 15 and 16 day values

     

    Show Less
  • forum
    New to Qlik Sense

    cumulative bar chart help in the attached app

    Hi Experts,Can any one please help me to build the below cumulative bar chart(like in second chart)Original chart has the data like below in first cha... Show More

    Hi Experts,

    Can any one please help me to build the below cumulative bar chart(like in second chart)

    Original chart has the data like below in first chart.

    Requirement

    I have to build a cumulative bar chart with May to Jan sorting and need to show the highest value on May like second chart.

     

    cumulative chart.png

    Please help me on this. I have tried the default accumulation but getting May with low value.

    Please find the below attached application and source file.

    Thanks in advance.

    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