issue in scenario??

[#1]

hi

this is siva

if have a data like this

product      date              price

i phone      1/1/2017     70000

i phone       5/1/2017    50000

htc            15/1/2017    30000

suppose if i select a date i.e 3/1/2017 in the list box

the table box has to show price of i phone  which is '70000'

if i select '5/1/2017'. the table box should show price of iphone

on 1/1/2017 as well as 5/1/2017

please help me to achieve this task

thanks in advance

[sushil353]

hi,

Try something like this:

add dimension product and date in you straight table and in expression

sum({<date = {"<=$(Max(date))"}>}price)

[Anil_Babu_Samineni]

I am doubt this you want to do it in Table box? I didn't get it this part. If it is straight/pivot object you can do like below

sum({<date = {"$('<=' & =Max(date))"}>}price)

[#4]

hi,

i tried this but the problem is if i select 5/1/2017 in list box , the chart is showing all the dates price i.e.

'1/1/2017',5/1/2017,'15/1/2017'

in my task it should show only 1/1/2017 and 5/1/2017 price

[#5]

hi

i above expression is not getting

[Anil_Babu_Samineni]

May be date issue with you

LOAD product, Date(date) as date, price;

LOAD * Inline [

product,      date          ,    price

i phone ,     1/1/2017     ,70000

i phone  ,     5/1/2017   , 50000

htc       ,     15/1/2017,    30000

];

Or

sum({<date = {"<=$(=Max(date))"} >}price)

[#7]

hi

its getting

thanks alot

[Anil_Babu_Samineni]

Awesome, Then you may close this thread by flag "Correct Answer"