Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

How to set up filters for straight tables?


Hi,

I'm trying to use expressions as data filter for my straight table but it doesnt work. I want to show only transactions that have value lowered than lets say 50 USD. I've flagged those in script as "if(TransactionValue<50,1,0) as SmallTransaction"

Than i've set up an expression

=(sum (SmallTransaction)=1,0,1)

than selected in Presentation "Max Number" as "0" but nothing happens

What's more - im trying to use 3 such flags / expressions simultaneously in the same table - all where "0" is the value im looking for (as in example =(sum (SmallTransaction)=1,0,1)

Can anyone tell what im doing wrong and how to change that?

I've tried to use dimension limits but for some reason that works quite slow on large data sets.

Thanks a lot!



5 Replies
Not applicable

Re: How to set up filters for straight tables?

I would try this to sum flagged transactions:

sum(SmallTransaction)

If you're giving transactions < 50 a value of 1 on import and calling the field SmallTransaction, then this should work.

Best,

Matt

jaimeaguilar
Valued Contributor II

Re: How to set up filters for straight tables?

Hi,

you need to sum the field where the value of transaction is contained, not the SmallTransaction flag. That flag is used to filter data. Using Set analysis you can get something like:

sum({$<SmallTransaction = {1} >} Value)

Take a look at the attached example,

regards

Not applicable

Re: Re: How to set up filters for straight tables?

If I understand correctly, you want to sum the flag. One of the purposes of a flag is to avoid set analysis and just use a sum function which is less resource intensive. I've attached an example where I use the sum(SmallTransaction) to present of table of transactions with values of < 50.

Perhaps upload an example if we're misunderstanding your requirement.

Hope that helps.

Matt

Not applicable

Re: How to set up filters for straight tables?

Hi Captain,

Were you ever able to solve this?

Matt

Not applicable

Re: How to set up filters for straight tables?

Yes,

both your answers were helpful. forgot to tag

Thanks a lot!

Community Browser