Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Presenting the next day value

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?

1 Solution

Accepted Solutions
lironbaram
Partner - Master III
Partner - Master III

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

View solution in original post

6 Replies
lironbaram
Partner - Master III
Partner - Master III

in the stright table use this set analysis

in your expressions:

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

Not applicable
Author

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

lironbaram
Partner - Master III
Partner - Master III

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

Not applicable
Author

some thing like that:

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

it gives me zero...

lironbaram
Partner - Master III
Partner - Master III

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

Not applicable
Author

thank you !!!