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

Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
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?

Labels (1)
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 !!!