Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
cancel
Showing results for 
Search instead for 
Did you mean: 
BrianDH
Creator II
Creator II

Filter QVD Data by Boolean

I am trying to filter out all records that are not 75% or greater.

Proj75overFilter:
LOAD
FISCAL_YEAR AS jFisYear
,ACCOUNTING_PERIOD AS jActPer
FROM [lib://QVD Files/PeopleSoft/Proj75over.qvd]
(qvd)

where
FISCAL_YEAR <= 2020
and ACCOUNTING_PERIOD <=12

and (Sum(SPEND)*100/Sum(BUD)>=75.00
;

Suggestions?

Labels (2)
1 Reply
hallquist_nate
Partner
Partner

Since no one esle is answering, I would typically do this in a two step process.  First I would load the table as a temp table, and do the needed calcuation.  Then, I would do a resident load of that table with the appropriate WHERE clause.  It is a bit clunky, but it will work and is pretty simple.  Just remember to drop your temp table after the resident load.  

 

There is likely a way to do this with a GroupBy function, but I have not explored that at all.

 

Good luck,

Nate