Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
peekay
New Contributor II

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
Contributor II

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
Valued Contributor III

Re: Disabling filtering of a dimension

Load

QTR ,

 ABC,

DEF

From Abc.xlsx

where Left(QTR,4)=2019;

Community Browser