Multiple filters within set analysis

Anonymous — Thu, 27 Jun 2013 14:20:26 GMT

Hi all,

I am trying to set an additional filter to a straight table I already have, so that the table would only show orders created on the day it is viewed.

The expression I already have is the following:

sum({<Tilaustyyppi-={'70-Tarjous','80-Toimitus',
'10-Projekti','60-MyynLaina','72-Prospekti','74-RahTarj',
'HuolTarj','81-Varsiirto'}>} AvoinTilausmäärä*Hinta)

It is in Finnish, Tilaustyyppi means order type, AvoinTilausmäärä means open orders and Hinta means price (if this helps). So it is basically open orders times price with certain order types ignored ('70-Tarjous' etc.). Pvm (means date) is the field I have for the order date to be used in filtering.

Could I use something like

sum(({<Pvm={$(=today(0))},
{<Tilaustyyppi-={'70-Tarjous','80-Toimitus','10-Projekti',
'60-MyynLaina','72-Prospekti','74-RahTarj','HuolTarj',
'81-Varsiirto'}>} AvoinTilausmäärä*Hinta)

to only show orders created on the day of viewing?

Thanks,

Juho

Re: Multiple filters within set analysis

swuehl — Thu, 27 Jun 2013 14:25:46 GMT

Try like this

sum(

{<

Pvm={'$(=today(0))'},

Tilaustyyppi-={'70-Tarjous','80-Toimitus','10-Projekti', '60-MyynLaina','72-Prospekti','74-RahTarj','HuolTarj', '81-Varsiirto'}

>}

AvoinTilausmäärä*Hinta)

Re: Multiple filters within set analysis

Anonymous — Fri, 28 Jun 2013 06:00:24 GMT

Worked like a charm, thank you!

topic Re: Multiple filters within set analysis in QlikView

Multiple filters within set analysis

Re: Multiple filters within set analysis

Re: Multiple filters within set analysis