Nested if statement/application of dual condition

[#1]

Hi guys,

I'm preparing a simple bar chart with 'Date' as my dimension and want to display sum of jobs processed in old environment vs sum of jobs processed in new environment. I need to display the sum only w.r.t query no.

I need set analysis formula to include two conditions together for new environment data.

I've tried using

sum({<Date={'11/16/2016'}>}if([Query No.]=('Query 3'),[NEW No. of orders progressed]))

sum({<[NEW No. of orders progressed]>}  if(Date='11/21/2016' ,if([Query No.]=('Query 3'),[NEW No. of orders progressed])))

both are not working for me

but filtering only for query is working

sum({<[No. of orders progressed]>}  if([Query No.]='Query 5' ,[No. of orders progressed]))

[maxgro]

try (assuming MM/DD/YYY is your date format)

sum({$ <Date={'11/16/2016'}, [Query No.]={'Query 3'}>} [NEW No. of orders progressed])

[Anil_Babu_Samineni]

OR One more expression this?

sum({$<Date={"$(=MakeDate(11/16/2016))"}, [Query No.]={'Query 3'}>} [No. of orders progressed])

For Filter, You can change like below

sum({<[Query No.]= {'Query 5'}>} [No. of orders progressed]>})