Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
how can i exclude current selection in set analysis for example if i have 2017Q1 data if i select this it should show only 2016Q1 and 2016Q2 it shouldn't show 2017Q1. my expresiion is as below
=if(YearQuarter = '2017Q1',
count({<YearQuarter={'2016Q1'},YearQuarter={'2016Q2'} >} ITEM))
please help me
Hi Hima
your logic is a little bit weird ..
when you select 2017Q1 , you want to sum data from 2016Q3 to 2016Q4 ?
and when you select 2016Q3 , you want only data from 2016Q1 ?
what data do you want to show when you select 2016Q1 or 2016Q2 ?
Hi Dave,
i want count of created Items and shipped items,if i clicked on 2017Q1 then i need previous year And Quarter Data.
i have below fields
Created date,
shipped date
Item
not quite clear about your requirement, hope this counld help you
PLease share a sample app
Maybe
=Count({<YearQuarter = -YearQuarter>} ITEM)
Hi Anil,
i i have 5 quarter's of data like 2017Q1,2016Q4, 2016 Q3, 2016 Q2, 2016 Q1
if i select 2017Q1 data it should show only 2016Q4 AND 2016Q3 if i select 2016Q3 i need only 2016 Q1 like this i need and i dont want to show the selected year.
please help me on this.
Why not 2016 Q2 for 2016 Q3??
the requirement is like that if the user select 2017Q1 he want to see only 2016Q4 and 2016Q3 if user select 2017Q2 he want see 2017Q1 2016Q4 2016Q3
For this, Make sense to me. Perhaps this?
count({<YearQuarter -= {">=$(=Max(YearQuarter-3)) <$(=Max(YearQuarter))"}>} ITEM)
No anil its not working can u try with count({1-$}ITEM) it is displaying all Quarter's Except current selection. but i dont need entaire set