topic Re: Filter Data in QlikView

Filter Data

siddheshmane — Sat, 19 Sep 2015 06:55:51 GMT

Hi,

I have a straight table with data.

I need to filter the data according to a particular value. say "Sales Order".

I want to show data of only "Sales Order" other should not be visible.

Thanks,

Siddhesh.

sunny_talwar — Sat, 19 Sep 2015 06:57:24 GMT

Try this as your dimension (and select 'Suppress When Value Is Null' on the dimension tab)

=If(SALESTYPE_FLAG = 'Sales Order', YourDimensionField)

HTH

Best,

Sunny

siddheshmane — Sat, 19 Sep 2015 07:00:54 GMT

Hi Sunny,

Have done that in my dimension field. But the filter i want to put is in my expression. Is it possible.

Thanks.

sunny_talwar — Sat, 19 Sep 2015 07:02:38 GMT

Sure. Add a set analysis statement to your expression:

{<SALESTYPE_FLAG = {'Sales Order'}>}

siddheshmane — Sat, 19 Sep 2015 07:04:13 GMT

Thanks a lot Sunny.

sunny_talwar — Sat, 19 Sep 2015 07:05:14 GMT

I am glad it worked

Best,

Sunny

siddheshmane — Sat, 19 Sep 2015 07:22:22 GMT

One more question. Is it possible to do the calculations on a Table Box instead of a Straight table.

sunny_talwar — Sat, 19 Sep 2015 07:29:38 GMT

Table box doesn't allow for calculated expressions. You can only use fields calculated in script.

Best,

Sunny