I just started my career as Data Analyst. I'm super excited to found your channel. Will surely spread this wonderful channel to my peers. Blessed you brother
Hello, I have a question about ' this year sale': This is my formular: sum({} UnitPrice*Quantity), because I don't know your measure 'Sales Amount', so I just replaced it by ' UnitPrice*Quantity'. The output result is same as the result of sum( UnitPrice*Quantity).
Hey gary, Yes, that is right. UnitPrice * Quantity is the formula for Sales Amount. output should be the Sales for the Max year, or a year you have selected.
After creating this expression for the master measure "Current Year Sales", the result is identical to the master measure "Sales". Syntax for the "Current Year Sales" expression: "sum({} UnitPrice*Quantity)". Syntax for the "Last Year Sales" expression: "sum({} UnitPrice*Quantity)". Both these two measure result equal to "Sales". The syntax for the "Sales" expression is "sum(UnitPrice*Quantity). I don't understand what I might be doing wrong 😥
@@thinkmetrics Still doesn't work. If I write this --> Sum({}SalesAmount) it gives me an Error in the expression message( I already created the master measure Sales Amount so that's not the problem). If I write this --> Sum({}UnitPrice*Quantity) it works but the result is still the same to the measure "Sales".
Ok, I hadn't seen the end of the video where you showed how you added Year and Sales Amount in the Data Load Editor :D Tip: Maybe you could move that section in the beginning of the video before you start the visualization :D
🎓 Get the Qliksense masterclass : www.thinkmetrics.se/masterclass
📕 Get the Formula CheatSheet: www.thinkmetrics.se/cheatsheet
I got way too excited when those bubbles turned red, haha! Thank you for these tutorials, they are incredible
🙌🏻🙌🏻🙌🏻
Your videos are really helpful for my new position. Keep up the good work.
Thanks a lot 😊. !
Thanks It was crystal clear ✨ Very helpful
You're welcome😊
I just started my career as Data Analyst. I'm super excited to found your channel. Will surely spread this wonderful channel to my peers. Blessed you brother
Thank you! Appreciate the kind words!😊. Good luck with Qliking 🙌🏻
Thank you so much, I learnt a lot from your videos. Could you please make video time intelligence function in qlik sense ?
🙌🏻
So cool!
🙌🏻
Hello, I have a question about ' this year sale':
This is my formular: sum({} UnitPrice*Quantity), because I don't know your measure 'Sales Amount', so I just replaced it by ' UnitPrice*Quantity'. The output result is same as the result of sum( UnitPrice*Quantity).
Hey gary,
Yes, that is right. UnitPrice * Quantity is the formula for Sales Amount.
output should be the Sales for the Max year, or a year you have selected.
Hi Kaush
Your videos are crystal clear and informative, good that I've found your channel in while searching for Qlik Sense references
Thanks a lot.
After creating this expression for the master measure "Current Year Sales", the result is identical to the master measure "Sales".
Syntax for the "Current Year Sales" expression: "sum({} UnitPrice*Quantity)".
Syntax for the "Last Year Sales" expression: "sum({} UnitPrice*Quantity)".
Both these two measure result equal to "Sales". The syntax for the "Sales" expression is "sum(UnitPrice*Quantity).
I don't understand what I might be doing wrong
😥
You're missing a '=' sign
Sum({}SalesAmount)
Sum({}SalesAmount)
Hope It helps
@@thinkmetrics Still doesn't work. If I write this --> Sum({}SalesAmount) it gives me an Error in the expression message( I already created the master measure Sales Amount so that's not the problem).
If I write this --> Sum({}UnitPrice*Quantity) it works but the result is still the same to the measure "Sales".
Ok, I hadn't seen the end of the video where you showed how you added Year and Sales Amount in the Data Load Editor :D
Tip: Maybe you could move that section in the beginning of the video before you start the visualization :D
@@stevenesposito9305 haha great! Thanks for the tip.