Certifications

I’m an SQL/BI Developer and my name is Deepak Vadithala…

I absolutely love working with technology!

If you have any questions at all about QlikView, please let me know! I absolutely love working with QlikView and supporting our awesome community. I can’t promise you that I’ll always be able to answer all of your questions myself, but I can certainly get you heading in the right direction.

You can reach me directly at my details below, on Twitter(@dvadithala) or find me on the QlikView Community.

At QlikShare, My aim is to share the learnings from the QlikView community or other sources. I believe that my posts should have a start and have an end. You should have learnt from everything that is in the middle. Confucious informs us: what we are told, we forget; what we are shown, we remember, what we do, we understand. So here, I aim to show you; through my short videos, which typically run 7-10 minutes and break complex tasks down into a series of simple steps. I’ll add videos frequently to share whatever new things I learn. If you need me to cover a specific topic, then please email me. In this way, I aim to empower you to do.

Thank you for visiting.

Disclaimer:

  • Just in case, if I say something stupid in the future, it’s better to be able to point out that the stupidity is mine, and mine alone. My stupidity! You can’t have it!
  • This is my personal weblog. I share my own personal thoughts and opinions about QlikView. The views and opinions on this Blog do not represent those of my employer.

Happy learning.

Cheers,

DV

80 Comments

  1. Mohit
    Dec 05, 2016 @ 19:13:51

    Sir, will you be able to provide qlik training to me?

    Reply

  2. Pravin
    Aug 20, 2016 @ 13:49:08

    I am considering to sign up your QlikView server & publisher course. But I don’t have the environment to practice it. Does course fee include environment? If not, can I hire the environment to practice?

    Reply

  3. Joydip
    Jan 31, 2016 @ 20:17:30

    Dear Deepak,
    I’m regular visitor of your blog as well as youtube channel. I already subscribed there. Lots of things I found there which i was searching for long and your videos gave me proper solution. One think if possible please share with us i.e. IntervalMatch() function. Put some real business scenario where it can be used and show us how to solve using IntervalMatch(). Will wait for your earnest reply.

    Thanks in advance,
    Joydip

    Reply

  4. qlikview Online Training classes
    Dec 21, 2015 @ 11:11:59

    thanks

    Reply

  5. Avva Ramesh
    Sep 20, 2015 @ 22:36:36

    Hi Deepak,
    This is Ramesh

    Reply

  6. SJ
    Jul 19, 2015 @ 20:51:27

    Hi deepak

    You just doing great job I’m great follower of your blog, all of are short and very cool
    thanks for your time sharing your experience on Qlik.

    Keep going cheers.

    Reply

    • DV
      Jul 19, 2015 @ 21:59:38

      Thank you Suvesh!

      Reply

  7. Anusha
    Jun 03, 2015 @ 18:34:16

    Hi Deepak
    Is there a way to show value on data points inside and outside the bar chart at the same time?For eg.If I have a stacked chart I want to show values for the individual break up and the total on the top as well

    Thanks
    Anusha

    Reply

  8. sukanta
    Apr 03, 2015 @ 09:40:57

    Hi DV,

    I have installed VMWare in my laptop & m practicing Hadoop using that. Is there any way to integrate QlikView with Hive using VMWare for practice?

    Reply

  9. sukanta das
    Apr 03, 2015 @ 07:05:41

    Hi DV,
    I want to make a career in qlikview. Can you please help me to follow the road map ? As of now I have studied qlikview randomly. Being a highly experienced person you must have the view to achieve this goal in a better way. Waiting for your response.

    Thanks a ton in advance

    Reply

  10. VV
    Mar 22, 2015 @ 22:58:59

    Hi Deepak,
    I recently posted in QlikCommunity for some help with Set Analysis expression. Could you please let me know? You can search for Purchase Price Variance expression in Qlik Community.

    Thanks,
    VV

    Reply

  11. Mart
    Mar 16, 2015 @ 21:19:40

    Thanks for all the very informative videos you have posted on QlikView. They have been very helpful.

    I have a number of QV docs that contain some complex scripting, four in total. Each file represents a business unit of a company such as finance, energy, maintenance etc. There is another QV doc that, KPI, that summaries all the key points of the other QV docs. I would like to create a sheet in this KPI doc from which I can create a monthly report containing tables, graphs and charts from all the other QV files. Do you have any thoughts on this please?

    Thanks,

    Reply

  12. tom
    Jan 28, 2015 @ 13:39:04

    Hi DV,

    I have a problem with Qlikview. To calculate the utilization I have to different fields, startDate & endDate. The time between needs to be in a chart. I think I need to use ValueLoop but don’t know how….

    could you help me out.

    Greetings,

    Tom
    Graduate Student

    Reply

  13. S Krishnakumar
    Nov 11, 2014 @ 01:19:19

    Dear DV

    I am a new user for QV.

    1. How can I add a “Store Layout Plan” to QLIK?
    – Store layout plans is a CAD Drawing.

    eg.
    Store No:
    101 – when I click the store no , I would like t see the layout of the store
    102 –
    103 –
    104 – etc

    Kind Regards
    S Krishnakumar

    Reply

  14. Sankara Rao Ballari
    Oct 26, 2014 @ 10:56:36

    Hi Deepak,

    First of All I need to appreciate for your enthusiam to provide your solution for multiple issues on Qlikview.

    I need some help to show the symbol in chart should be blinking.
    1. I have one line for daily count of month & another line avg of previous month

    The requirement is compare daily count with Avg & highlight in different colour on the daily count line with blinking if the diff is more than 10%

    Reply

  15. SM
    Sep 22, 2014 @ 17:26:09

    Hi Deepak,
    I need some help regarding a file. How do I email you the file so that you can look at it. It’s a one page word doc.
    Help would be appreciated greatly.

    Thanks,
    Shashank

    Reply

  16. Samuel Onilado
    Sep 03, 2014 @ 09:40:54

    Hi Deepak, are you currently available for contract work?

    I’m after a QlikView developer for a global organisation.

    Contact me on samuel.onilado@it-talent.co.uk to let me know your situation.

    Reply

  17. Saurabh
    Aug 26, 2014 @ 04:14:06

    Hi Deepak ,

    i m facing an issue regarding reload of an application . its generally reloads fine but sometimes it doesn’t reload . dont why .. Could you advise me ? Please find the attached Log ..

    The task “Application.qvw”
    failed. Part of the log file follows:

    8/26/2014 6:07:10 AM Error Failed to read ScriptErrorCount.
    Exception=System.Runtime.InteropServices.COMException (0x80010100): System call failed. (Exception from HRESULT: 0x80010100 (RPC_E_SYS_CALL_FAILED))
    at QlikView.Doc.GetVariable(String _Name)
    at QVBWrapper.Document.Reload(ILogBucket i_LogBucket, Boolean i_MonitorQVBCPUUsage, Boolean i_Partial, Boolean i_ReadDocumentLog)
    8/26/2014 6:07:10 AM Error The Source Document was NOT reloaded
    successfully. DocumentPath=D:\QLIKVIEW
    APPS2\SOURCE \Application.qvw.
    8/26/2014 6:07:12 AM Error The task
    “Source2/ Application.qvw” failed.
    Exception:
    QDSMain.Exceptions.DistributionFailedException: Distribute failed with errors to follow. —> QDSMain.Exceptions.ReloadFailedException: Reload failed —> QDSMain.Exceptions.LogBucketErrorException: The Source Document was NOT reloaded successfully. DocumentPath=D:\QLIKVIEW APPS2\SOURCE\Application.qvw.
    at QDSMain.ReloadTask.VerifyConditions(TaskResult taskResult)
    at QDSMain.ReloadTask.Reload(String fileName, TaskResult taskResult, String sectionAccessUserName, String sectionAccessPassword, eReloadOptions reloadOption, String variableName, String variableValue, Boolean
    moniterCpuUsage)
    — End of inner exception stack trace —
    at QDSMain.ReloadTask.Reload(String fileName, TaskResult taskResult, String sectionAccessUserName, String sectionAccessPassword, eReloadOptions reloadOption, String variableName, String variableValue, Boolean
    moniterCpuUsage)
    at QDSMain.DistributeTask.Execute(TaskResult currentTaskResult)
    — End of inner exception stack trace —
    at QDSMain.DistributeTask.Execute(TaskResult currentTaskResult)
    at QDSMain.Task.AbstractTask.TaskExecution(ILogBucket logBucket, TaskResult taskResult)

    Reply

  18. Rama Sai
    Aug 08, 2014 @ 07:37:04

    Hi Deepak,

    From my side small help, is there any video which contain all topics covered in qlikview with some examples? if yes please send that file link to me.In advance thanks for u r help.
    if u r providing any online classes please let me know i want to join.i saw u r blogs those are very good and easy to understand.

    Reply

  19. Herbert Chitate
    May 04, 2014 @ 17:39:15

    Good evening,

    I have been working with Qlikview for about 5 months now and am looking for a Qlikview course that can really prepare me for certification exams, something like: http://www.quickintelligence.co.uk/training/ which is based on the book Qlikview 11 for developers. Am looking for training in either India or Southern Africa.

    Would you be able to provide some recommendations?

    Thank you

    Herbert

    Reply

  20. Don Saluga
    Oct 16, 2013 @ 20:05:37

    Thanks for taking the time to make the videos. They are very clear and concise. I like the pick() and Match() functions.

    Reply

  21. DV
    Oct 08, 2013 @ 08:32:30

    You?re welcome Gilman. Yes, thanks to Donald.

    Reply

  22. Jeff Hickman
    Oct 02, 2013 @ 12:24:44

    Hello ? I just wanted to thank you for taking the time to post this material, and in particular the custom ?Clear All? logic. Also, thank to Donald for the [] comment; I?d realised that they were required but had them in the wrong place?
    Thanks

    Reply

  23. Melanie Michael-Greer
    Aug 23, 2013 @ 11:06:52

    Dear Deepak;

    Would you be interested in a QlikView Developer opportunity?

    I?m handling an excellent role for a hugely energised and lively client, and I?d love to talk to you in more depth about that.

    When you have a moment, could you let me know if we could have an initial discussion on the ?phone? I sense you have the passion, enthusiasm and intellect that my client are seeking.

    I look forward to hearing from you,
    Kindest regards,
    Melanie

    Reply

  24. Deepti
    Aug 08, 2013 @ 07:29:40

    Hi Deepak,

    Pleased to meet you!

    I am Deepti Thore, an Author Acquisition Executive at Packt. Packt Publishing is a print-on-demand publishing company which specializes in publishing books based on specific technologies and solutions. You can find more information about us at http://www.packtpub.com.

    This mail is regarding the proposal for Reviewing a book. The title of the book is ?QlikView Scripting?.

    I researched your profile, and felt that you would be an ideal person to review this book for us.

    The total page count of the book would be approximately 100 pages.

    As a token of thanks, your name and biography would be included in the ?About the Reviewer? section in the first few pages of the book.

    You will also be receiving two copies of the book: one eBook or print copy of the book you review and an eBook of your choice from our catalogue.

    For more details regarding reviewing, please visit http://www.packtpub.com/author_reviewing_for_packt.

    If you are interested in this proposal, then please let me know at the earliest. I would be happy to answer any questions you may have.

    Kind Regards,
    Deepti Thore
    Author Acquisition Executive|Packt Publishing|

    Reply

  25. Galilean
    Jul 01, 2013 @ 13:47:30

    Hi Deepak,
    Thanks for all the helpful videos. It has saved me many a times. 🙂

    Have a question: I need to link 2 tables by Account ID. But still filter by Date.
    However the Date in ATM Table may not exist in the ? Date in Cheque Table
    I cant link by Date, as this will cause a syntax error.

    How would u solve this? Thanks for the advice.

    ATMTable:
    Date1, Account ID, Amount
    ChequeTable:
    Date2, Account ID, Amount

    Galilean

    Reply

  26. RJ Samp
    Jun 03, 2013 @ 16:00:52

    Just went through your For Next Loop video?.and combined it with Rob Wunderlich?s QVC toolkit to create and incrementally store 189 tables from SalesLogix CRM. SalesLogix has a table with all of the tablenames, their primary key field (generally Table Name + ?ID?), and the Last Modified Record datetime stamp (usually ModifyDate).

    Qlik View 11, SQL Server 2012, (SalesLogix 7.5x and it will work in SLX 8).

    // Load/Store as QVD files:
    // All SalesLogix tables
    // June 3, 2013 RJ Samp

    // Added Deepak Vadithala?s For Next Loop to read all SLX ResynchTableDefs TableNames.
    // Sdded Rob Wunderlich?s QVC Incremental QVD Loader scripts to incrementally load all QVD tables\files.
    // ======================================================//

    Sub LoadTableNames
    SQLTableList:
    LOAD
    TABLENAME AS TableNames,
    KEYFIELD as KeyFields,
    DATESTAMPFIELD as DateStampFields;

    Sql
    SELECT
    TABLENAME, KEYFIELD, DATESTAMPFIELD
    FROM
    sysdba.RESYNCTABLEDEFS
    WHERE
    ISNULL(KEYFIELD, ?) > ? AND ISNULL(DATESTAMPFIELD, ?) > ?
    ORDER BY TABLENAME ;
    End Sub;

    // ======================================================//

    Call LoadTableNames;

    // ======================================================//

    Let vTableCount = NoOfRows(?SQLTableList?) ? 1;

    // ======================================================//

    Sub LoadTableData
    For i = 0 To $(vTableCount)
    LET vMyTableName = Peek(?TableNames?, $(i), ?SQLTableList?);
    LET vMyBaseTableName = ?$(vMyTableName)? & ?_BASE?;
    LET vMyPrimaryKeyFieldName = Peek(?KeyFields?, $(i), ?SQLTableList?);
    LET vMyUpdateColumnFieldName = Peek(?DateStampFields?, $(i), ?SQLTableList?);
    //STORE $(vMyTableName) INTO $(Directory)$(vMyTableName).QVD;
    //DROP Table $(vMyTableName);
    // Calling parameters are QVTablename, UpdateColumn, PrimaryKey.
    CALL Qvc.IncrementalSetup (?$(vMyBaseTableName)?, ?$(vMyUpdateColumnFieldName)?, ?$(vMyPrimaryKeyFieldName)? );

    // v.Tablename is set by IncrementalSetup
    [$(Qvc.Loader.v.Tablename)]:
    // Whatever LOAD and SELECT goes here
    SQL SELECT * FROM sysdba.$(vMyTableName)
    // v.IncrementalExpression is set by IncrementalSetup
    WHERE $(Qvc.Loader.v.IncrementalExpression) ;
    // Update the QVD with the changed rows
    CALL Qvc.IncrementalStore;

    Next i

    End Sub;

    // ==========================================================================================//

    Call LoadTableData;

    // ==========================================================================================//

    CALL Qvc.Cleanup;

    // THANKS!!!

    Reply

  27. Sushma.Koyi
    May 08, 2013 @ 18:42:00

    thanks a lot for posting this qqotd. It?s very helpful for newbies like me.

    Reply

  28. Santosh
    Apr 25, 2013 @ 14:30:17

    Deepak
    I am new to Qlikview. Where can I see more video?s on Join.
    Best regards
    Santosh

    Reply

    • Sandy
      Jul 21, 2016 @ 20:54:26

      Kick the tires and light the fires, problem ofilciafly solved!

      Reply

  29. Ajit Pahuja
    Apr 17, 2013 @ 00:21:32

    Hi Deepak,

    This is with regard to the Custom OnClearAll document even in Qlikview at http://qlikshare.com/856.

    I have tried the similar function in my file but I am not able to implement that. The function is exactly written the same way as you have been. It works fine till the concat level but when I go for the the $ expansion, it cripples.

    Could you provide me with some reasoning for this. I am not able to attach the qvw file with this post but in case you provide me with you e-mail, I can easily do that.

    The function I am using is

    =$(=concat(DISTINCT ?GetSelectedCount(?& $Field & ?)?, ? + ?))

    Thanks.

    Regards,

    Ajit

    Reply

  30. Gwain
    Mar 02, 2013 @ 19:23:22

    Hi

    First of all, congratulations for your blog. It?s actualy a mine !
    I?ve created the same type of blog about Qlikview but in french.
    Is it possible to add my site in your blogroll ?
    Best regards

    Reply

  31. Rajesh Bhardwaj
    Feb 19, 2013 @ 15:34:00

    Hi There.

    Firstly I would like to say that I really enjoy getting hints and tips from your blog. I am using it now as my regular avenue to get QlikView help rather than go the QlikTech community page regularily. I think that video tips actually shows you the scenario you are working with and also shows how to solve the problems.

    I have a question about the IntervalMatch function. I have seen many examples of IntervalMatch on the QlikView community and in the training manuals provided but I am unable to get my head around it.

    Do you have a comprehensive video tip in your blog about this? It would be great to have a little insight on this.

    Keep up the good work.

    Rajesh

    Reply

  32. DV
    Feb 18, 2013 @ 10:30:34

    Don ? You are absolutely right and having the square braces is very important. I shall amend my post. Thanks again!

    Reply

  33. Donald Hutchins
    Feb 12, 2013 @ 16:31:03

    Thanks so much for putting together the helpful videos and content. Very well done!

    In your video tutorial on the custom ClearALL event trap, one enhancement you may want to consider is wrapping the field name in [braces]. In my case, I tried this where one of the fields in my data model is ?MMM-YYYY?, and the hypen caused a problem.

    So simply adding braces to qualify as a field worked well, i.e.:
    =IF($(=Concat(DISTINCT ?GetSelectedCount([‘ & $Field & ‘])?, ? + ?)) = 0, 1, 0)

    Thank you again,
    Don

    Reply

  34. Will Hill
    Feb 09, 2013 @ 00:18:29

    I would like to start by thanking you for all of the invaluable information that you have posted. A friend of mine brought me into this company in October to help develop a very impressive BI tool founded on Qlikview, and your tutorials have been a resource I?ve relied upon quite heavily to build my understanding.
    We have a new task that involves mapping. We?ve taken interest in expanding this extension
    http://community.qlikview.com/thread/45125
    Web development is not one of my strong suits. We would like to add additional layers to this example. A simple demonstration would be selecting a state, and the zip codes become available; then selecting all appropriate zip codes and relating those selections back to Qlikview. Any suggestions, caveats, alternatives, and coding examples would greatly be appreciated.
    Thank you for your time,
    Will

    Reply

  35. dd
    Feb 04, 2013 @ 16:02:43

    Can u suggest me, how to take positive values in Input field, if user wants to enter negative values, it should take only positive values instead of negative values. Please respond

    Thanks in Advance,

    Reply

  36. Sandeep Hamelink
    Jan 31, 2013 @ 13:24:40

    I would like to have multiple sort_weight wihin a firstsortedvalue expression

    example

    firstsortedvalue(number,KWALIFICATIE_NIVO,BEKOSTIGD,
    OMVANG_OPLEIDING, ISNULL(DATUM_UITSCHRIJVING, DATUM_GEPLAND_EINDE) ,VERBINTENIS_NUMMER DESC)

    gr. sandeep

    Reply

    • Ellie
      Jul 01, 2016 @ 18:35:59

      Some of us use false version numbers as a pseudo honeypot to catch bad guys looking for specific exploits. It turns out you can have as many such meta tags as you like. If you are one such user of meta data, don't forget to disable the google notices, or you will often be told you are running an old version, reresdlags of reality 🙂

      Reply

  37. Sandeep Hamelink
    Jan 28, 2013 @ 19:44:51

    My example is to long, but i solved a part of my problem. The thing i did not solve s posted here:

    http://community.qlikview.com/message/304529#304529

    Reply

  38. Sandeep Hamelink
    Jan 28, 2013 @ 09:29:37

    The eample is to big to send

    Reply

  39. Sandeep Hamelink
    Jan 28, 2013 @ 09:02:15

    http://community.qlikview.com/message/304529#304529

    this page explains it. i solved a part of my problem, but not all. When my discussion has been loaded, you can use my example.

    Reply

  40. Sandeep Hamelink
    Jan 28, 2013 @ 08:59:01

    Dear DV,

    My problem has been solved partially by me, but i still have a problem. On this page you can find it, including example files.

    http://community.qlikview.com/message/304529

    Gr. Sandeep

    Reply

  41. DV
    Jan 27, 2013 @ 23:46:19

    Dear Sandeep,

    It?s easy to look at the data and work with your script. Please can you post the sample QVW file? You can directly email me?

    Thanks,
    Deepak

    Reply

  42. DV
    Jan 27, 2013 @ 23:45:31

    No problem Sandeep

    Reply

  43. DV
    Jan 27, 2013 @ 23:44:07

    Hi Gaurav,

    Please check my tweet or add ?=? at the beginning of the expression while assigning the variable. If you still have issues then please email me directly and we can work together?

    Thanks,
    DV

    Reply

  44. Sandeep Hamelink
    Jan 25, 2013 @ 10:40:31

    Sorry for posting twice. Because of an error i assumed it did not work the first time,

    Gr. Sandeep

    Reply

  45. Sandeep Hamelink
    Jan 25, 2013 @ 10:39:41

    Dear Deepak Vadithala

    I want to make this calculation using AND and OR within an expresion and the use of firstsortedvalue:

    (PEOPLE_GRADUATED * 100) / TOTAL_PEOPLE

    TOTAL_PEOPLE = COUNT ALL PEOPLE

    PEOPLE GRADUATED =

    TYPE_ONDERWIJS = BO AND

    STARTOCTOBER <= DATE_EXIT AND DATE_EXIT < TODATE AND (SUCCES = 1 AND X = 1) OR (LEAVVE = 1 AND Y=1) X = COUNT PEOPLE WHERE SUCCES = 1 STARTOCTOBER = SCHOOLSTART AND DATE_EXIT < TODATE // i want to use firstsortedvalue for sort by. SORT BY KWALIFICATION DESC FUNDED SIZE EDUCATION ISNULL(DATE_EXIT, DATE_ENDPLANNED) DEC CONNECTION NUMBER Y = COUNT PEOPLE WHERE EXIT = 1 STARTOCTOBER = SCHOOLSTART AND DATE_EXIT < TODATE // i want to use firstsortedvalue for sort by. SORT BY IF(SUCCES NOTNULL, KWALIFICATION, ElSE 'NIVEAU0)' FUNDED SIZE EDUCATION ISNULL(DATE_EXIT, DATE_ENDPLANNED) DEC KWALIFICATION DESC CONNECTION NUMBER Good luck

    Reply

  46. Sandeep Hamelink
    Jan 25, 2013 @ 10:37:55

    I have a question about using AND and OR within an expression and using firstsortedvalue

    I want to make this calculation:

    (PEOPLE_GRADUATED * 100) / TOTAL_PEOPLE

    TOTAL_PEOPLE = COUNT ALL PEOPLE

    PEOPLE GRADUATED =

    TYPE_ONDERWIJS = BO AND

    STARTOCTOBER <= DATE_EXIT AND DATE_EXIT < TODATE AND (SUCCES = 1 AND X = 1) OR (LEAVE = 1 AND Y=1) X = COUNT PEOPLE WHERE SUCCES = 1 STARTOCTOBER = SCHOOLSTART AND DATE_EXIT < TODATE // i want to use firstsortedvalue for sort by. SORT BY KWALIFICATION DESC FUNDED SIZE EDUCATION ISNULL(DATE_EXIT, DATE_ENDPLANNED) DEC CONNECTION NUMBER Y = COUNT PEOPLE WHERE EXIT = 1 STARTOCTOBER = SCHOOLSTART AND DATE_EXIT < TODATE // i want to use firstsortedvalue for sort by. SORT BY IF(SUCCES NOTNULL, KWALIFICATION, ElSE 'NIVEAU0)' FUNDED SIZE EDUCATION ISNULL(DATE_EXIT, DATE_ENDPLANNED) DEC KWALIFICATION DESC CONNECTION NUMBER Good luck Sandeep

    Reply

  47. Gaurav
    Jan 24, 2013 @ 05:43:15

    not getting 1 or 0 on writing expression
    =$(=Concat(DISTINCT ?GetSelectedCount(? & [$Field] & ?)?, ?+? ))

    Please help me
    Regards,
    Gaurav

    Reply

  48. DV
    Dec 11, 2012 @ 13:37:57

    Good luck Sujeet! Please check microsoft website they provide sample databases.

    Reply

  49. DV
    Dec 11, 2012 @ 13:32:44

    Hi KG,

    You?re welcome. I?m glad you liked them.

    I?ll check the community thread and try my best to answer your question.

    Cheers,
    DV

    Reply

  50. KG
    Dec 11, 2012 @ 11:51:55

    Hi Deepak,

    Your posts have helped me a lot with my problems in the past. Thanks again for that!

    I have been facing an issue for quite sometime now and thought your inputs would be very helpful. Could you please check the QV community post below?

    http://community.qlikview.com/thread/67234?tstart=0

    Thanks,
    KG

    Reply

  51. Sujeet
    Dec 08, 2012 @ 20:39:05

    Hi Deepak,

    I am new to qlikview. I just got lots of information from your videos.But it would be great if i could get some sample data to work on with.

    Thanks,
    Sujeet

    Reply

  52. Purna
    Dec 07, 2012 @ 02:09:14

    Thanks for your help DV. I would like to know are you interested in doing work from remote. If so, please respond to this email.

    Thanks,
    Purna.

    Reply

  53. Neil Gulliver
    Nov 26, 2012 @ 13:56:33

    Hi, Deepak.
    I have only recently had a requirement to use Google maps and I loved your youtube video on how to use Google map extensions in QlikView.

    I have a question: is the size and shape of the pins on the map defined in the java script somewhere ? Or is it predefined and I need to find a more appropriate extension ?

    I am looking to produce a map with just simple pins or markers showing the location of schools in the UK.

    Thanks,
    Neil.

    Reply

  54. DV
    Nov 03, 2012 @ 10:21:25

    Please check QlikTech official training, other QV blog (listed on my blog), QlikView Community and QlikView Reference Guide are the good starting points. You can install the free desktop edition and you can start practising immediately.

    Good luck and happy learning.

    Cheers,
    DV

    Reply

  55. suman
    Oct 17, 2012 @ 13:47:25

    Hi Deepak,

    I have 1 year experience in report experience. i want move qlikview side.

    1.is qliktech provide free training or not. if not how much they ask for training
    2. what are the opportunities for 1 exp in qlikview.

    please give me suggestion

    thanks
    suman

    Reply

  56. Vidit
    Oct 09, 2012 @ 17:00:21

    Hi Deepak,

    Great initiative?thanks for sharing your knowledge..

    I wanted to know if you have any idea about ArcGIS extension in Qlikview for interactive maps..

    Thanks
    Vidit

    Reply

  57. Qlikview Forum
    Oct 06, 2012 @ 05:46:16

    Hi Deepak

    I did not get any reply for above post of mine. Hope you can help me out atleast for this.

    http://community.qlikview.com/message/266732#266732

    Thanks,
    Qlikview Forum

    Reply

  58. Qlikview Forum
    Aug 20, 2012 @ 16:54:44

    Hi Deepak,

    I would like to know ?How to load data from sharepoint which needs authentication??

    http://community.qlikview.com/message/249859#249859

    Thanks

    Reply

  59. Andy
    Aug 15, 2012 @ 15:25:38

    Hi DV

    Have you encountered any issues with print buttons?

    I have put a print button on my report. On my desktop version, it works great, opening a dialogue box that allows me to either print a page, or the whole report. However, when I view the online version of the qlikview document, the print button doesn?t do anything at all.

    Have you come across this before? If so, do you know how to fix it?

    Thanks in advance

    Kind Regards

    Andy

    Reply

  60. DV
    Aug 02, 2012 @ 20:19:40

    Hi Maria,

    Welcome to QlikView world! I?d recommend reading Reference Guide and help documentation. Also, there are many blog (Please look at my blogroll). I?ll email you directly.

    Happy learning!

    Cheers,
    DV

    Reply

  61. Maria
    Aug 02, 2012 @ 14:39:22

    Hi DV

    I?m new in Qlikview and I want to know if you know or you have some material, like books where I can learn in a formal way about Qlikview11, I have done all the training that is available in the Qlikview.com but I?m looking for a further training.

    Thank you in advance for your help!

    Greetings from Ecuador

    Reply

  62. DV
    Jul 28, 2012 @ 20:34:05

    VK ? Many thanks for your comments. That?s good idea and I?ll share the historical questions along with answers.

    Thanks,
    DV

    Reply

  63. vk
    Jul 27, 2012 @ 19:00:26

    Hi DV,

    firstly thanks for your QV videos.

    QQotD is a nice way share stuff, however it would be even better if we can be able to find old questions. Whats ur say?

    Cheers
    VK

    Reply

  64. DV
    Jul 25, 2012 @ 20:01:44

    Sure. Please email me and I?ll mock up something for you.

    Cheers ? DV

    Reply

  65. Nate
    Jul 25, 2012 @ 17:54:37

    Thanks. I?ve got a sample example .qvw I could email you if you?d like something simple to start with.

    Reply

  66. DV
    Jul 25, 2012 @ 05:49:22

    Thank you Nate. I?ll come back with an example and I?ll drop you an email or upload the file on my blog.

    Thanks ? DV

    Reply

  67. Nate
    Jul 25, 2012 @ 01:49:44

    Great site. I had a question about highlighting the Min and Max values on a line chart. How can I do this with 2 dimensions? I work in the health care field, so my line chart dimensions are Doctors and Reporting Period (time). The expression would be doctor productivity. If I choose more than 1 doctor, how can I show the max and min on each line?

    Reply

  68. DV
    Jul 21, 2012 @ 08:46:06

    Arun ? I?d recommend using reference guide for learning purposes or please contact QlikTech Training Division if you want their training material. Sorry I couldn?t help you.

    Cheers ? DV

    Reply

  69. arun goel
    Jul 20, 2012 @ 11:56:16

    hi,

    Do you have Qlik VIew Developer course material (QV 10 or 11) which is provided by QlikTech in training,
    if yes, Plz mail me?

    Thanks.
    arun
    (arun.goel007@gmail.com)
    ?

    Reply

  70. DV
    Jul 11, 2012 @ 20:20:50

    Thanks for the comment. Sorry, I don?t provide training but I would recommend you to contact QlikTech for formal training.

    Reply

  71. Swamy
    Jul 10, 2012 @ 15:22:03

    Hi,
    Do you also provide online qlikview training or can you please recommend your colleagues who provides Qlikview training?
    Thanks,
    Swamy

    Reply

  72. DV
    Jul 02, 2012 @ 20:28:38

    Thanks Sajid. I?ve emailed you directly. Good luck!

    Cheers,
    DV

    Reply

  73. Sajid Mahmood
    Jun 29, 2012 @ 09:26:16

    Hi
    I liked your videos. Can you support me on designing the data model from Oracle E-business suite for funtional areas like PO, AP, AR OM GL etc.

    Since Oracle EBS is complex in database tables structure, I would require some advanced technical support.

    My first query is how to make sure that the data is accurate mapped in Qlikview from EBS.

    I am also ready to pay your consultancy fees, if you would like to support me on one-one basis.

    Reply

  74. DV
    Jun 11, 2012 @ 11:21:39

    Hi Ranganth,

    Please access the QVW & Google Maps Extension Object zipped file (QAR) from QlikView Community.

    Here is the link :

    http://community.qlikview.com/message/153412#153412

    I hope this helps!

    Cheers,
    DV

    Reply

  75. Ranganath
    Jun 10, 2012 @ 09:39:58

    Hi,
    Please can you share google maps extension object which you have shown in youtube if you don?t mind.

    With Regards,
    Ranganath

    Reply

  76. DV
    Jun 05, 2012 @ 14:19:49

    Hi,

    Please can you share the QVW file? or the sample CSV file and I?ll try on my system.

    Thanks,
    Deepak

    Reply

  77. Lars Errebo
    Jun 05, 2012 @ 13:04:50

    I have a problem following your example regarding the extension with Google map. I?m currently using Qlikview version 11.00.11282.0 SR1. After load of data from the csv file I can not modify the google map object to relate to lat and lng. ??? Could you help?

    Best regards

    Lars Errebo

    Reply

Leave a Reply

*