Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Show data for Only January Month

Hi,

I wanted to show the data for only January Month in the pivot table for the respective year.

for ex if I select year 2017 then the table should show me the values for 2017 Jan month irrespective of month selection.

Please find attached file for reference.

1 Solution

Accepted Solutions
Highlighted
Specialist III
Specialist III

Re: Show data for Only January Month

Hi,

In Set Analysis you can set the Month =1

Like below:

Expression:

=Avg({<Continent = {'Asia','Europe','North America'},Month={'1'}>} Actual)

View solution in original post

1 Reply
Highlighted
Specialist III
Specialist III

Re: Show data for Only January Month

Hi,

In Set Analysis you can set the Month =1

Like below:

Expression:

=Avg({<Continent = {'Asia','Europe','North America'},Month={'1'}>} Actual)

View solution in original post