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. I believe that my posts should have a start and have an end. You should have learnt from everything that is in the middle. So the idea is to create short videos on QlikView.  I believe that the best way to learn is by watching and listening, especially when you’re starting a new topic. I’ll build short videos that typically run 5-10 minutes and break complex tasks into a series of simple tasks. I’ll add videos frequently and if you need me to cover a specific topic then please message me. I hope you find the content valuable. In all cases, I welcome people to comment on what I share, for good or for bad. I am sure we’ll all get along fine.

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

Twitt

50 Comments

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

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

  2. 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

  3. 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

  4. 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

  5. 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

  6. 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!

  7. 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

  8. 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

  9. 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,

  10. 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

  11. 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

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

    The eample is to big to send

  13. 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.

  14. 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

  15. 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

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

    No problem Sandeep

  17. 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

  18. 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

  19. 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

  20. 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

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

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

    Please help me
    Regards,
    Gaurav

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

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

  23. 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

  24. 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

  25. 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

  26. 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.

  27. 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

  28. 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

  29. 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

  30. 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

  31. 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,

  32. 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

  33. 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

  34. 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

  35. 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

  36. 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

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

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

    Cheers – DV

  38. 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.

  39. 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

  40. 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?

  41. 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

  42. 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)
    …

  43. 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.

  44. 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

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

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

    Cheers,
    DV

  46. 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.

  47. 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

  48. 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

  49. 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

  50. 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

Leave a Reply

*