Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
We use Week Filter In Qv Report when select Week-1 then sum (IndentQty*20/100) when Select Week-2 then Sum (IndentQty*25/100) as so on, Its Working fine For me but when we select Week-1 and Week-2 Both then Filter Not apply My expression is Given below Please help,
if(WEEK='WEEK-1',Sum((IINDENTQTY*20)/100),
if(WEEK='WEEK-2',Sum((IINDENTQTY*25)/100),
if(WEEK='WEEK-3',Sum((IINDENTQTY*25)/100),
if(WEEK='WEEK-4',Sum((IINDENTQTY*30)/100),
if(WEEK ='WEEK-1,WEEK-2',Sum((IINDENTQTY*45)/100),sum(IINDENTQTY))))))
HI Vijay
I have sorted this by creating a variable to store the value of the selected value from the list box and an if formula as an expression
variable: WeekValue=Concat(distinct WEEK,',')
Expression:
if(WeekValue='Week-1',sum(IINDENTQTY)*0.2,
if(WeekValue='Week-2' or WeekValue='Week-3',sum(IINDENTQTY)*0.25,
if(WeekValue='Week-4',sum(IINDENTQTY)*0.3,
if(WeekValue='Week-1,Week-2',sum(IINDENTQTY)*0.45,sum(IINDENTQTY)))))
Regards
Padma
Try to write like
if(WEEK='WEEK-1',Sum((IINDENTQTY*20)/100),
if(WEEK='WEEK-2',Sum((IINDENTQTY*25)/100),
if(WEEK='WEEK-3',Sum((IINDENTQTY*25)/100),
if(WEEK='WEEK-4',Sum((IINDENTQTY*30)/100),
if(Match(WEEK ,'WEEK-1' , 'WEEK-2' ),Sum((IINDENTQTY*45)/100),sum(IINDENTQTY))))))
But Its Not Working for Me
You have to do change in the expressions and where are you using this expression in any text object or chart otherwise you have to do aggregation in the expression.
Hi We have Attach Qv Sample please Check..
Hi Vijay,
In your data model the week field is independent in nature and it is not related to the IINDENTQTY then how you get data reflected for the QTY table please check.
Hope this helps
HI Vijay
I have sorted this by creating a variable to store the value of the selected value from the list box and an if formula as an expression
variable: WeekValue=Concat(distinct WEEK,',')
Expression:
if(WeekValue='Week-1',sum(IINDENTQTY)*0.2,
if(WeekValue='Week-2' or WeekValue='Week-3',sum(IINDENTQTY)*0.25,
if(WeekValue='Week-4',sum(IINDENTQTY)*0.3,
if(WeekValue='Week-1,Week-2',sum(IINDENTQTY)*0.45,sum(IINDENTQTY)))))
Regards
Padma
Hi
Please see attached sample tables
Regards
Padma