Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have sales data from 2016001 to 2020012.
date format is : 2016001 to 2020012.
I need to show only 2016-Q1 to 2019-Q4 in bar chart.
I have created two variables in script for starting quarter(2016-Q1) and ending quarter(2019-Q4).
It is working fine for year and month level data but for quarter only it is not working.
variables for year is:
Let less= Year(Today())-2;
Let great= Year(Today())+1;
expression for year is: Sum({$<[Fisc_Year]={">=$(=less)<=$(=great)"}>}Sales)
Above expression showing values for : 2016,2017,2018 and 2019.
variables for Quarter is:
Let vDateMin= Year(Today())-2 &'-'& 'Q1';
Let vDateMax= Year(Today())+1 &'-'& 'Q4';
I have used these variables in set expression but I m not getting data.
my expression is:
Sum({<[Fisc Qtr]={">=(vDateMin)<=(vDateMax)"}>} Salary)
please find attached files for reference.
Thanks in advance.
regards
venkey.
May be try this (not recommended, but if you really want to)
=Sum({<date={">=$(less)<=$(great)"}, [Fisc Qtr] -= {"*-Q0"}>} Salary)
Why don't you use the same expression for when you Fisc Qtr as a dimension
=Sum({<date={">=$(less)<=$(great)"}, [Fisc Qtr]>} Salary)
Thanks Sunny, It is working fine.
But my quarter field having 2016-Q1,2016-Q2----2017-Q1--2018-Q0,2018-Q1,2018-Q2 till 2019Q4.
here 2018-Q0 is having 2018001,2018002 till 2018012 i.e. it is having full year data.
I need to remove from the result dataset.
could you please give me solution for that requirement.
regards
venkey.
@venkey2847 wrote:here 2018-Q0 is having 2018001,2018002 till 2018012 i.e. it is having full year data.
2018-Q0? Where do you see this? I am not sure I understand what you are looking to do?
I am telling that in my quarter field I have, so I need to remove.
regards
venkey.
Yes Sunny.