Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Customers, Partners & Luminaries only: You're invited to a Data Analytics Roadmap session. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

dimension is changed by set analysis ??

Hi experts,

I got a strange problem in a very simple data set. qvw is attached.

My data set is very simple, just like below:

'data':
load * Inline [
date,ID,val
'5/12/2020', 100, 1
'4/30/2020', 100, 2
'5/12/2020', 101, 10
'4/30/2020', 101, 20
]

in dashboard, I put a list box for "date" field so user can select a date. I put a calendar which is connected to a variable vDate. Then I have a table, dimension is "date" and "ID", express is like below:

=max({1<date={'$(=Date($(vDate)))'}>} val)

Note I use "1" and date in the set analysis. basically what I want is , when date is selected as 5/12/2020, and calendar is set to be 4/30/2020, I want the table to show the val of 4/30. It shows the correct val but why the date column is 4/30? It should be 5/12 because I'm selecting 5/12 in the list box, right?

untitled.png

the qvw file is attached.

 

Thanks,

Michael

Labels (1)
2 Solutions

Accepted Solutions
Highlighted

Try this

=Aggr(Above(Max({1}val)), ID, (date, (numeric)))

View solution in original post

Highlighted

Try this

=Aggr(Above(Max({1<date = {"$(=Date($(vDate)))", "$(=Date(Max(date)))"}>}val)), ID, (date, (numeric)))

View solution in original post

6 Replies
Highlighted

May be try this

=Above(Max({1<date={'$(=Date($(vDate)))'}>} val))
Highlighted
Creator
Creator

hi,

this seems to be not working. What I want is actually something like below,

untitled.png

 

but my expression gives me this. I don't understand why 4/30 rows are in the table even though I have selected the date 5/12 in list box.

Capture.PNG

Highlighted

Try this

=Aggr(Above(Max({1}val)), ID, (date, (numeric)))

View solution in original post

Highlighted
Creator
Creator

Hi,

thank you for the solution. but i just found this only works when I have two dates, what if I have more dates and I want user to choose different Compare Date from the calendar and the table should be updated automatically?

a new qvw is attached with more data, I tried modifying the expression, but can't get it work..

 

Thanks,

Michael

Highlighted

Try this

=Aggr(Above(Max({1<date = {"$(=Date($(vDate)))", "$(=Date(Max(date)))"}>}val)), ID, (date, (numeric)))

View solution in original post

Highlighted
Creator
Creator

Thank you!