Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
CUSTOMERS ONLY: Now accepting customer applications for the 2023 Luminary Program: SUBMIT 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;