Qlik Community

Ask a Question

New to QlikView

If you’re new to QlikView, start with this Discussion Board and get up-to-speed quickly.

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Digital Support
Digital Support

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.