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

Announcements
Learn how to migrate to Qlik Cloud Analytics™: On-Demand Briefing!
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.