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: 
flames
Contributor III
Contributor III

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

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

Load

QTR ,

 ABC,

DEF

From Abc.xlsx

where Left(QTR,4)=2019;