topic Re: Filter Dimensions in QlikView

Filter Dimensions

amiroh81 — Mon, 16 Jun 2014 08:07:34 GMT

Hello all,

I know what I want to do should be simple but I'm complicated performing ...: (

I have a table with Dimensions and I want to show only the rows that meet certain conditions (and only on this table).

For example I have a column of STATE and I want to show only the rows that the STATE = BLOC

How do I do this?

I tried to put conditions through the EDIT but he did not get it.

Thanks in advance

Re: Filter Dimensions

alexandros17 — Mon, 16 Jun 2014 08:14:23 GMT

Write as dimension:

if(STATE = 'BLOC', STATE, Null())

and check the box "suppress where value is null

Let me know

Re: Filter Dimensions

MK_QSL — Mon, 16 Jun 2014 08:15:42 GMT

You can use in script something like below

Load *

From TableName

where STATE = 'BLOC';

In UI side

Use Calculated Dimension

IF(STATE = 'BLOC', STATE)

and Tick Suppress When Value is NULL

Use Whatever expression you want...

Re: Filter Dimensions

mdmukramali — Mon, 16 Jun 2014 08:16:13 GMT

Dear,

kindly find the attached file.

i hope it will help you.

Thanks,

Mukram.

Re: Filter Dimensions

amiroh81 — Mon, 16 Jun 2014 08:21:26 GMT

its work,

i did it before but i didnt check the 'Suppress When Value is NULL' box.

i found anotherway,

on expression i dfined =Match( STATE ,'BLOC')

and its work also.

thank you very much everybody!

Re: Filter Dimensions

its_anandrjs — Mon, 16 Jun 2014 08:26:22 GMT

So you got the solution there are many ways

In load script you can filter

Load * from Location Where Match( STATE ,'BLOC');

In Expression

Sum(IF(Match( STATE ,'BLOC'), YourValue )

In Calculated Dimension

Match( STATE ,'BLOC')

If( Match( STATE ,'BLOC'), STATE)

But select suppress when value null