Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Highlighted
flames
Not applicable

Disabling filtering of a dimension

I have a Table. and I want to restrict one dimension to a specific quarter.

 

QTR      ABC   DEF

==================

2019     Y         Y

0              Z         K

2018        K       A

2019       M       Z

 

I need to get the below output:

QTR      ABC   DEF

==================

2019     Y         Y

 

2019       M       Z

 

2 Replies
zzyjordan
Not applicable

Re: Disabling filtering of a dimension

Hi, Peekay

Have you tried 

=if(QTR='2019', QTR)

and then tick off Include Null Value as shown below?Untitled.jpg

Hope this helps

ZZ

 

ramasaisaksoft
Not applicable

Re: Disabling filtering of a dimension

Load

QTR ,

 ABC,

DEF

From Abc.xlsx

where Left(QTR,4)=2019;