Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
HermGerm
Contributor II
Contributor II

Dimensions: Only show specific values in Pivot

Hi,

I have a Pivot table for the actual Month - regardless what the user selects.

The first dimension should only show the calendar weeks of the actual Month.

My Table MainCalendar looks like this:

MainDate            MainDateMonth           MainDateCalendarWeek                     MainDateYear

04.07.2019         7                                          27                                                                  2019

05.07.2019         7                                          27                                                                  2019

...

So how to write the Dynamic Dimension, so it shows only the calendar weeks from the actual month which is "today" and ignores users selection.

Please see attached Image, what I expect for today (5th july 2019)

PS: Ive got two variables (vGetActualMonthNum) and (vGetActualYear) which returns the current month and year

 

1 Reply
Brett_Bleess
Former Employee
Former Employee

Believe you are going to want to use Set Analysis for this one:

Help: 

http://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/ChartFunctions/S...

Design Blog: 

https://community.qlik.com/t5/Qlik-Design-Blog/Dates-in-Set-Analysis/ba-p/1472511

https://community.qlik.com/t5/Qlik-Design-Blog/A-Primer-on-Set-Analysis/ba-p/1468344

Best I have, hopefully it may help you move things forward.

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.