วีดีโอ

Thanks!

Hi Manish, I have a doubt. On UPDATE, as per our code we are only concatenating new record to existing salesorder.qvd, but we are not updating the details of updated record in qlik salesorder.qvd correct? but thanks for the videos they are detailed.

Hi can you do video for PYQTD

Nice explain

Can we get total in last in pivot table

What is the use of it

Very informative video. Thanks soo much

Very informative video. Thanks soo much

Great explanation for a not so trivial topic. Also worth mentioning that the same principle applies for Before / ColumnNo if you have a Pivot table with the months in the columns.

Hi Manish, Your video is so helpful for new learners, so please keep continue and create such kind of video.

Instead of using * for section access of Admin we can leave that row as blank for Admin

Hi @ManishKachhia Could you please provide data sample data for practice which you are using here

how can find the all Apps are used by QVDs

for year 2021 i am getting zero value (since products from laptop category is CCC only and products from mobile category is DDD only AND no products when we are performing intersection between CCC and DDD) , seams like this is happening as i am using the latest version of QLIK . Please verify for the latest version of Qliksense and update this video if required. {<Year={$(=max(Year)-1)}>} sum( { <Customer=P({<Product={'Laptop'}>})> * <Customer=P({<Product={'Mobile'}>})> } Sales)

very helpful videos, much appreciate , just one feedback - mouse is making irritating noise, use trackpad instead

very helpful videos, much appreciate , just one feedback - mouse is making irritating noise, use trackpad instead

Super informative videos. Please create new videos to learn qlik 😊

Great content Manish, kudos to you for this wonderful playlist on Section Access

Thank you 👍

This is great! The main issue I’m having is when there are no weeks with sales and when selecting other dimensions in the data. I then it goes back to only weeks or months where there were sales rather than total sales as of latest month or week.

Manish , the content is really rock solid and helps to brush up your interview in quick succession. Kudos to you Manish for this content

Thank you very much! 👏

Please make a video on how incremental load works without primary key

Very well explained.. how can we achieve if we don’t know the qvd exists or not please explain

Thank You Manish, Really i understand in a very better way about the concepts which you explained.

What a detailed explanation really you are giving, Since i have experienced in qlik sense but when i saw your videos am asking my self do i really know the qlik. Learning a lot. Heartfully thanks for uploading the videos.

🙏❤️

Amazing to see such a clear, structured and well explained video. 👍Its so helpful!!

😊🙏

Hello Manish, can we convert a measure into dimension using aggr function ? I have a nested if condition where i am calculating a measure which is represented as a text in the front end in the table as ‘Yes’ or ‘No’. I would want to use it in the filter to see yes and no both. Is it possible?

If you use Exists(OrderID) but OrderID is not in the LOAD statement, is it not optimized. This one has caught me more than once!

Hi Manish Sir, if we don't want to use calculated dimension and need to do this in the backend. So, when we are doing group by based on Brand. If we add Category and Country in the group by then it should work, right? I'm not able to download the data I guess it is expired.....

Really superb

Please create a video on Sheet level access using section access

Please drop more videos on QMC

Please drop more videos with such a good information

Thank you for the Knowlege, Cant we use the interval match function here?

Hi Manish sir, I need help here. After selecting anyone of the bucket. The countries selection are appearing. Instead of can we display bucket selected range in selection bar?

Thank you Sir for this excellent learning video. And, quick question, when referencing the loop counter Var in the Peek fx of the For Loop Exercise (around 16:19), I have noticed the var works with or without being expanded? How is it so...& what is the best practice? Thank you

for last five videos there is no Audio for the video.

Nicely Explained , Thank you.

Excellent. As always Manish, you have explained it very clearly and simple.

Thank you👍🏻

Please send data file

Hi , small doubt how the where not exist works here ? We don't need to Concatenate the currency with date right ibviously that combination doesn't exist right and it should not eliminate the duplicate right I.e. we are comparing 01.07.2023 - 1.21 with 01.07.2023 - - how come this is eliminating the duplicate

Very powerful, highly useful and well explained. This is the case with all of your videos. You are a gifted teacher and presenter and I totally appreciate the succinctness of your efforts.

Very slick! Thanks Manish

Is this the efficient optimized way of loading combinations dynamically shown in this video ? OR using for each value ( cross join method ) showing in Video 7 / 8 ?

Ideally this scenario of Concatenate and then using Where not Exists - This should be tackled in the security table in the database that should be kept up-to-date. Then there is no need to do concatenate and where not exists. Let me know what do you think.

Amazing content! Thanks man!