topic Disabling filtering of a dimension in QlikView

Disabling filtering of a dimension

flames — Wed, 25 Nov 2020 16:16:04 GMT

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

zzyjordan — Thu, 10 Jan 2019 04:47:29 GMT

Hi, Peekay

Have you tried

=if(QTR='2019', QTR)

and then tick off Include Null Value as shown below?

Hope this helps

ramasaisaksoft — Thu, 10 Jan 2019 07:21:26 GMT

Load

QTR ,

ABC,

DEF

From Abc.xlsx

where Left(QTR,4)=2019;