Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello all,
In the red markered column in straight table there's no Sales data. I expected in this column sales data based on startdate 01-12-2014 and enddate 31-12-2014).
Which set analysis / script codes should i use to get the data in the red markered column?
Thank you very much.
Greets,
Rega
I think, yes...
Could you share the expression for Sales LY??
StartDate and EndDate are variables or fields?
Using combination of Date(),Addyears(), or Addmonths() we can achieve same
Hi,
Check this
https://community.qlik.com/docs/DOC-5103
Hope this helps,
Hirish
Hi,
Hope this link will help
Expression:
Sum( {$<DateField = {“>=$(=Min(StartDate))<=$(=Max(EndDate))”} >} Sales LY)
Hello Balray,
This is the currenct expression for Sales LY :
sum({<Year={$(=max(Year)-1)}>}SalesPrice*TransactionQuantity)/1000
variables
Hi Guys,
none of your answers above has solved the problem. It;s kinda urgent.
Is there anybody who are able to do a screen sharing session today? i have no prefer using tools such as teamviewer/Skype etc.
Waiting for your answer.
Greets,
Rega
Since they´re variables you don´t need to worry about Max() and Mins()´s, onlky care about formatting values
This should be enough
sum({<YourDateField={">=$(=Date(StartDate)) <= "$(=Date(EndDate))" "}>}SalesPrice*TransactionQuantity)/1000