Filter data

[Jeka]

Hello!

I am a new one in Qlik and need help.

I have data about competitors prices. I need to make filter and calculate date in this way:

1) Simple competitors 

2) Marketplace Legal competitors 

3) Marketplace Illegal competitors

I need two variants in filter:

1. All competitors

2. Legal competitors 

If user chooses Legal competitors in table will be information of Simple competitors + Market place Legal competitors.

If user chooses All competitors in table will be information of Simple competitors + information of Marketplace competitors with min price on position.

For example:

ItemId  CompSourse  CompName  TypeLegal  Price

1             Origin                  Comp1            1                   100

1              Marketplace    Comp2             1                   120

1              Marketplace     Comp3            0                    110

If user chooses Legal competitors:

ItemId  CompSourse  CompName  TypeLegal  Price

1             Origin                  Comp1            1                   100

1              Marketplace    Comp2             1                   120

If user chooses All competitors:

ItemId  CompSourse  CompName  TypeLegal  Price

1             Origin                  Comp1            1                   100

1              Marketplace     Comp3            0                    110

I don't know how to create filter which always shows one part of date and switch only between another one.

I have thought  of using Aggr function to show proper date but leader of BI system said that this functions can be used only in extreme situations not in regular counting...

Can you advise me any solution of such problem. I can't find any solution in others topics...

[MartW]

it depends on where you want the filters to apply. 

if in the frontend then you can simply drag a filterobject on to the canvas. after that you can select the dimensions you want to filter.

if you want to do this in the load script you can use a resident load (with a no concatenate and where statements) to filter data (basic filtering)

your BI lead is smart to say that aggr function should be avoided because this can indeed cause some performance issues.