QlikView Scripting | Joins

QlikView Join is an important Data Modeling feature that you'll encounter in your day to day work. If you know SQL then you'll be well aware that they help us get the data as per our Business requirements and then accordingly we can develop the BI Solution.

In this video I've given a walk through on how to use the joins by utilizing the example of previous "Concatenation" video for the sake of simplicity in understanding the different type of Joins.

I hope you'll find this video useful and an addition to your existing learning of QlikView.

-Abhishek

[pralaysangma]

Very simple but very useful video. Thank you for the great work.

[anneeinhorn]

I really like your videos, many thanks

[bakytbeckbeck]

as always: very clear and understanding, Thank you Abhishek

[Robert]

Very simple and well explained. Thank you

[SurenderKumar-eibh]

Thanks for the videos Abhishek. I am working on one of the projects and want to know the script to directly link the excel file with QlikView. I don't want to repeat the step "Select Field" again and again if I am adding any new field in excel file. I just want to simply reload the data and all field and data should reflect in QlikView without adding field throuh "Select Field" properties. It would be really helpful for me if you can assist me on this. Thank you...

[muraliprasath]

Very Use for beginners. Thanks for your all videos. :-)

[jeffmonroe]

Thanks for the video Abhishek, I will be sending you an email requesting the datafiles you use in your videos so I can try out your techniques.

[venkatchinna]

hi abishek this is venkat. Is there any chance you do teach online teaching ? if u do plz let me know

[nadiahnoorlin]

hi abhishek.I want to ask you how to associates 35 excel files together. Let say I have 35 products which is equal to 35 excel files. I want to combine all 35 excel files together. I used association but only data from 1 product of excel file is visible on the dashboard?how do I encounter this problem?