need help in requirement

siva8 — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

i have a table like below

product,date, price

apple iphone ,1/1/2019,30000

one plus,5/1/2019,35000

apple iphone ,15/1/2019,40000

my requirement here is as explained as below in scenarios

scenario 1:

in calendar object if i select 2/1/2019 the straight table should show [product apple] and [price of apple] [(i.e. 30000) --- latest price at 2/1/2019]

scenario 2:

and if i select 10/1/2019 the table should show [product apple and onplus ]and price of the both [i.e. 30000 and 35000].------- latest price at 10/1/2019

scenario 3:

and if i select 20/1/2019 the table should show [one plus and apple ] and price of both [i.e. 35000 and 40000] --- because the latest price at the time of 20/1/2019 for apple and one plus was 35000 and 40000 respectively .

finally if i select any particular date in a calendar object the table should show latest prices of product .

thanks in advance

thanks

siva

Re: need help in requirement

siddheshmane — Sun, 22 Dec 2019 10:17:34 GMT

Hi Siva,

Assuming you have a master calendar table setup to select any dates for which you want to see the data.

I stored the date selection in a variable and then used the below set expression to display my values.

MAX({<DATE = {'<=$(=vdateselect)'}>}PRICE)

Hope this helps.

Regards,

Siddhesh H Mane.

topic Re: need help in requirement in QlikView

need help in requirement

Re: need help in requirement