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

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Ignore date selection from calendar but not other filters

And it's me again.

I use the calendar range extension where I use Date(Floor(Date(TimeStamp,'MM/DD/YYYY hh:mm:ss.ffff')),'DD/MM/YYYY') as a Dimension. In addition, I added two more filters on the page (VISIT_VSL_NAME_AN and STOW_ACTIVITY_CODE).

In the graph, I want to compare the current year Export volume vs the last year. If no filter selection (VISIT_VSL_NAME_AN  or STOW_ACTIVITY_CODE) is made, the graph will show the overall trend. If the selection is made, the graph will show the trend for that selection.


I tried for this year line:

sum({1<[TimeStamp.Calendar.Year] = {"$(=Max({1}[TimeStamp.Calendar.year]))"}, SHIPPING_STATUS_CODE={'EX'}>} TEU). If a person selects this month, he will see the YTD trend line; last month - YTD trend line. It works fine when I apply other filters but then, when I make a calendar selection, it shows that month/date value, instead of showing the YTD trend line.


Another option I tried after reading the forum,

sum({1<[TimeStamp.Calendar.Year] = {"$(=Max({1}[TimeStamp.Calendar.year]))"}, SHIPPING_STATUS_CODE = {'EX', 'EXPRT'},

VISIT_VSL_NAME_AN=P(VISIT_VSL_NAME_AN), STOW_ACTIVITY_CODE=P(STOW_ACTIVITY_CODE)>}TEU) but it did not work.

I also thought of using TimeStamp=, TimeStamp.Calendar.Date= but I am not sure how to add the condition about the max year.

I suspect it's something basic here.

Many thanks,

10 Replies
Anonymous
Not applicable
Author

OK, I guess I will continue with the current formulas as even with the newly created calendar, I don't need to modify them - providing that I name the calendar fields the same way. Thank you.