topic Presenting the next day value in QlikView

Presenting the next day value

Wed, 05 Oct 2011 07:04:22 GMT

hi all,

i have a little problem that i realy dont know how to solve:

i have 2 table: 1 regular and the other is straight table , my problem is:

when pressing on day (from a day box list) i need that the data in the table will present the actual day selected data

and in the straight table i need to present the next day data.

pls, any suggestions?

Presenting the next day value

lironbaram — Wed, 05 Oct 2011 08:40:49 GMT

in the stright table use this set analysis

in your expressions:

{<day={"$(=max(day)+1)'}>}

Presenting the next day value

Wed, 05 Oct 2011 12:23:56 GMT

thank you very much for your answer liron,

i have succeeded to do it and now i get the value of the next day by selecting a day,

but now i have diffrent problem, if i select 2 days i want to present the values of these daysand i get only the last day value, i want to present all days values.

i.e. i am selecting the 1/10 and 2/10 and expect to see the the values of 2/10 and 3/10 .

i think the problem is with the max function... i have try some thinks but no success ,

any sulotion for that ?

avi

Presenting the next day value

lironbaram — Wed, 05 Oct 2011 12:26:22 GMT

{<day={">=$(=min(day)+1) <=$(=max(day)+1) '} >}

Presenting the next day value

Wed, 05 Oct 2011 12:34:59 GMT

some thing like that:

= sum ( { < Day = { ' >= $ ( = min(Day) + 1 ) <= $ ( = max(Day) + 1 ) ' } > } VALUE ) ???

it gives me zero...

Presenting the next day value

lironbaram — Wed, 05 Oct 2011 12:42:01 GMT

sum ( { < Day = {">= $ ( = min(Day) + 1 ) <= $ ( = max(Day) + 1 ) " } > } VALUE )

Presenting the next day value

Wed, 05 Oct 2011 12:50:58 GMT

thank you !!!