How to display dynamic column as per date criteria ?

[#1]

Hello all,

How one can display the dynamic column as per date criteria. Scenario has been enclosed for all of your reference. Help will be immensely appreciated.

Thanks, have a great time!!!

[HirisH_V7]

AFAIK no way,But some changes in the Requirement i.e by making the loops in the Script itself and creating required  columns dynamically and using them.

I believe we need to do some R&D for this model.

[vinieme12]

check the attached

[#4]

Enclosed qvw is the right one posted by hirishv7, but is there any dynamic way if i have above 100 expressions ....

how to including the loop concept in it.

Thanks Vineeth for your valuable time.

[vinieme12]

what I attached was a dynamic one, have you checked??

[#6]

so sorry didn't notice ......It's a dynamic one,will chk and get back to you ASAP

[vinieme12]

Hi stalwar1‌ , swuehl‌ , gwassenaar‌

I've been trying to go get this to work but couldn't.

On the below table what we need is if we select  19th April 2013

"Selected Column" to show data for selected date ie 19th April 2013 only

"Trailing": Should show data from  Jan(1-19),Feb(1-19).....to  April(1-19)

At the moment Date Selection is only calculating for selected Month , even though I've specified criteria in Set to evaluate from Month 1 to Selectedmonth

Thanks

Vineeth

[sunny_talwar]

vinieme12‌‌ are you looking for this?

Expressions

=if(Only({1}PeriodRange) = 'Trailing',

SUM({<Date = , DayofDate =, MonthofDate = ,DayofDate = {">=1<=$(=Max(Day((Date))))"} ,MonthofDate = {">=1<=$(=Max(Month(Date)))"}>}Amt)

,if(Only({1}PeriodRange) = 'Selected',

SUM({<Date = {"$(=Max(Date))"}, DayofDate =, MonthofDate = >}Amt)

))

=if(Only({1}PeriodRange) = 'Trailing',

SUM({<Date = , DayofDate =, MonthofDate = ,DayofDate = {">=1<=$(=Max(Day((Date))))"} ,MonthofDate = {">=1<=$(=Max(Month(Date)))"}>}Amt1)

,if(Only({1}PeriodRange) = 'Selected',

SUM({<Date = {"$(=Max(Date))"}, DayofDate =, MonthofDate = >}Amt1)

))

[vinieme12]

Fab as always  stalwar1‌

But can I ask you , why do we still use only() on PeriodRange, which is an dummy dimension when the Actual selection is on the Date field?

[vinieme12]

sadhan.damal‌, now you have a complete dynamic solution, use the expressions below by Sunny

[sunny_talwar]

Here you will see why

When 4/19/2013 is selected PeriodRange is only available for that day, rest of the days it is null. When I used {1}, regardless if your other selections, it is always available.

HTH

Best,

Sunny