topic Re: Usage of set Analysis in QlikView

Usage of set Analysis

arusanah — Tue, 14 Apr 2015 14:33:50 GMT

Can we use set analysis in Where clause ??

e.g i have to find customer sales for a payer for years 2013 & 2014 normally we use it in expression as

({$<TimeLine.Year={2013,2014}>}Fact.CustomerSales)/1000

every time i select data this condition gets re evaluated which makes app slower . i was wondering can we use this in where clause

where ({$<TimeLine.Year={2013,2014}>).

pls suggest

alexandros17 — Tue, 14 Apr 2015 14:57:07 GMT

Unfortunately set analysis cannot be used in a where clause, in your query you can write:

...

where TimeLine.Year='2013' or TimeLine.Year='2014'

let me know

buzzy996 — Tue, 14 Apr 2015 15:01:25 GMT

NO.

Tue, 14 Apr 2015 15:08:59 GMT

Try with the follow approach:

in Load statement (example):

LOAD

Year,

if(Year=2013 or Year=2014,1,0) as Flag1314

FROM [...];

in Set Analysis

Sum({<Flag1314={1}>}Fact.CustomerSales)