Hi Manish, Your video is so helpful for new learners, so please keep continue and create such kind of video.
@WasimShah-l6pАй бұрын
Instead of using * for section access of Admin we can leave that row as blank for Admin
@unnatipandey2909Ай бұрын
Hi @ManishKachhia Could you please provide data sample data for practice which you are using here
@kannekantiАй бұрын
how can find the all Apps are used by QVDs
@koustubhgoel68652 ай бұрын
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)
@swatikapoor-x1t2 ай бұрын
very helpful videos, much appreciate , just one feedback - mouse is making irritating noise, use trackpad instead
@swatikapoor-x1t2 ай бұрын
very helpful videos, much appreciate , just one feedback - mouse is making irritating noise, use trackpad instead
@raparnaaparna922 ай бұрын
Super informative videos. Please create new videos to learn qlik 😊
@dineshgudla37352 ай бұрын
Great content Manish, kudos to you for this wonderful playlist on Section Access
@BonJunCuevas2 ай бұрын
Thank you 👍
@Na-uy4ot2 ай бұрын
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.
@dineshgudla37353 ай бұрын
Manish , the content is really rock solid and helps to brush up your interview in quick succession. Kudos to you Manish for this content
@bayazjafarli38673 ай бұрын
Thank you very much! 👏
@bhargavireddychavva62803 ай бұрын
Please make a video on how incremental load works without primary key
@bhargavireddychavva62803 ай бұрын
Very well explained.. how can we achieve if we don’t know the qvd exists or not please explain
@SravanKumarReddy-n3x3 ай бұрын
Thank You Manish, Really i understand in a very better way about the concepts which you explained.
@SravanKumarReddy-n3x3 ай бұрын
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.
@wissawattaesuji3 ай бұрын
🙏❤️
@bigbrainwithabb16063 ай бұрын
Amazing to see such a clear, structured and well explained video. 👍Its so helpful!!
@wissawattaesuji4 ай бұрын
😊🙏
@rushalibhand49444 ай бұрын
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?
@manishkumarkachhia16834 ай бұрын
Yes
@KeyBorg14 ай бұрын
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!
@kartiksemwal13914 ай бұрын
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.....
@bollavinod40514 ай бұрын
Really superb
@devendrakhamkar29414 ай бұрын
Please create a video on Sheet level access using section access
@AnkitPandey-ju1ff4 ай бұрын
Please drop more videos on QMC
@AnkitPandey-ju1ff4 ай бұрын
Please drop more videos with such a good information
@sanketdhakare10824 ай бұрын
Thank you for the Knowlege, Cant we use the interval match function here?
@SurendraNandi-pv4mq5 ай бұрын
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?
@Kennedy-z3g5 ай бұрын
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
@nicholaspetre15 ай бұрын
Thanks! It's a good one!
@maneeshbuddha82535 ай бұрын
for last five videos there is no Audio for the video.
@saikatchatterjee21005 ай бұрын
Nicely Explained , Thank you.
@Robert84556 ай бұрын
Excellent. As always Manish, you have explained it very clearly and simple.
@BonJunCuevas6 ай бұрын
Thank you👍🏻
@chodipilliravikumar44596 ай бұрын
Please send data file
@samkaran63516 ай бұрын
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
@Robert84557 ай бұрын
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.
@Robert84557 ай бұрын
Very slick! Thanks Manish
@crownambassador17 ай бұрын
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 ?
@crownambassador17 ай бұрын
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.
@sirinaydin87867 ай бұрын
Amazing content! Thanks man!
@emilianoalvarez34127 ай бұрын
Thank you very much for your videos. They are really useful. Greetings from Argentina.
@rafiusk227 ай бұрын
Is the difference between using * and ALL just that ALL sees everything and * only what's in SA?
@Madina_analyst_support7 ай бұрын
Thank you for your lessons, they helped me a lot.
@RajaBhaiyaKahin8 ай бұрын
Good explanation. Better than Udemy courses!
@franktheisohn14148 ай бұрын
Very nice, structured and understandable Tutorial! Thank you - that helps a lot
@zsofiaszlanka93718 ай бұрын
One of the best Qlik Video I have ever seen.Many thanks
@FelipeReyes-d2w8 ай бұрын
Hi Manish, Great video. The columns work well but in my case I would need o add the sum in the qlik script of the backend and not as measure. Do you know how I can do that? Thanks!