topic Re: issue in scenario?? in QlikView

issue in scenario??

Wed, 25 Nov 2020 16:16:04 GMT

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

Re: issue in scenario??

sushil353 — Mon, 20 Mar 2017 06:03:44 GMT

hi,

Try something like this:

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

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

Re: issue in scenario??

Anil_Babu_Samineni — Mon, 20 Mar 2017 06:07:42 GMT

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)

Re: issue in scenario??

Mon, 20 Mar 2017 06:23:29 GMT

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

Re: issue in scenario??

Mon, 20 Mar 2017 06:28:12 GMT

i above expression is not getting

Re: issue in scenario??

Anil_Babu_Samineni — Mon, 20 Mar 2017 06:34:49 GMT

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

];

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

Re: issue in scenario??

Mon, 20 Mar 2017 06:43:34 GMT

its getting

thanks alot

Re: issue in scenario??

Anil_Babu_Samineni — Mon, 20 Mar 2017 06:46:48 GMT

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