topic Expression filter dimension in QlikView

Expression filter dimension

Fri, 11 Jul 2014 11:41:17 GMT

Hi, friends.

I have an expression...

(Rangesum(above(total Sum({$<[Séria]={Účtovníctvo}>}Čiastka),0,RowNo(total))))/(Rangesum(above(total Sum({$<[Séria]={Plán}>}Čiastka),0,RowNo(total))))

... which works correctly and I need to add a filter for dimension Obdobie <= UZAVRENEOBDOBI, where UZAVRENEOBDOBI is a dimesion. Both of dimensions OBDOBI and UZAVRENEOBDOBI have format Date, UZAVRENEOBDOBI has one record with value 1.5.2014 0:00:00.

I tried:

(Rangesum(above(total Sum({$<[Séria]={Účtovníctvo},[Obdobie]<={max(UZAVRENEOBDOBI)}>}Čiastka),0,RowNo(total))))/(Rangesum(above(total Sum({$<[Séria]={Plán},[Obdobie]<={max(UZAVRENEOBDOBI)}>}Čiastka),0,RowNo(total))))

(Rangesum(above(total Sum({$<[Séria]={Účtovníctvo},[Obdobie]={<=max(UZAVRENEOBDOBI)}>}Čiastka),0,RowNo(total))))/(Rangesum(above(total Sum({$<[Séria]={Plán},[Obdobie]={<=max(UZAVRENEOBDOBI)}>}Čiastka),0,RowNo(total))))

(Rangesum(above(total Sum({$<[Séria]={Účtovníctvo},[Obdobie]={'<=max(UZAVRENEOBDOBI)'}>}Čiastka),0,RowNo(total))))/(Rangesum(above(total Sum({$<[Séria]={Plán},[Obdobie]={'<=max(UZAVRENEOBDOBI)'}>}Čiastka),0,RowNo(total))))

No data.

Can you help me, pls. ?

Thanx in advance.

Duski

Re: Expression filter dimension

Anonymous — Fri, 11 Jul 2014 11:45:16 GMT

Hi,

try with

[Obdobie]={'<=$(=max(UZAVRENEOBDOBI))'}

[Obdobie]={'<=$(#=max(UZAVRENEOBDOBI))'}

greeting

Re: Expression filter dimension

Fri, 11 Jul 2014 11:59:56 GMT

Thank you, Irene.

No data for both formulas :-(.

Maybe the problem is date format ?

Thanx in advance

Duski

Edit1:

I tried also:

(Rangesum(above(total Sum({$<[Séria]={Účtovníctvo},[Obdobie]={'<=$(=max(date(UZAVRENEOBDOBI)))'}>}Čiastka),0,RowNo(total))))/(Rangesum(above(total Sum({$<[Séria]={Plán},[Obdobie]={'<=$(=max(date(UZAVRENEOBDOBI)))'}>}Čiastka),0,RowNo(total))))

(Rangesum(above(total Sum({$<[Séria]={Účtovníctvo},[Obdobie]={'<=$(#=max(date(UZAVRENEOBDOBI)))'}>}Čiastka),0,RowNo(total))))/(Rangesum(above(total Sum({$<[Séria]={Plán},[Obdobie]={'<=$(#=max(date(UZAVRENEOBDOBI)))'}>}Čiastka),0,RowNo(total))))

No data 😞

Duski

Edit2:

After restart of machine and QV I noticed, that the first formula works 🙂

Thank you once more, Irene.

Over.

Duski