Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

plz help me out i want sales for month of aug and sept and there differnce

i  uploaded  excel file  for  easy  reference of u

i want  sales  house   sales  of  for the month of  aug  and  sept only that to in staright  table

i  want the   fruits  wich was  sold  in house  

houseshophoue rateshop rate
Apple10215100.60.6
mangoes55472554723.93.9
banana323200
dry fuits35272400.1
tamatoo34437349040.60.7
total98501013471.11.1
1 Reply
qlikpahadi07
Specialist
Specialist

hi there is no attachment as such and regarding the query you can simply write three Expressions

  1. Sum({<Year = {$(=max(Year))}, MonthNum= {09}>}sales).............Sales for Sep Month
  2. Sum({<Year = {$(=max(Year))}, MonthNum= {08}>}sales).............Sales for Aug Month
  3. Sum({<Year = {$(=max(Year))}, MonthNum= {09}>}sales)-

          Sum({<Year = {$(=max(Year))}, MonthNum= {08}>}sales).... Difference

or can use Max(MonthNum) and Max(MonthNum)-1 same as Year to make dynamic