Load data without where condition in optimize way

[Anonymous]

hello

i have 1 table which is contain South, North, West, East data,i want to show data for only North region but i dont want to used where condition in it then how it is possible by using optimize way.

Thanks..

[Anonymous]

ok if i want to display value then how it is possible without using where clause.

[tajmohamed30]

[tajmohamed30]

I have used set analysis to filter out only north values from region field

=sum({1<Region={'North'}>}Sales)

Thanks

Taj Mohamed

[RSvebeck]

This is a solution without a where clause:

Data:

LOAD *

FROM Table;

inner join(Data)

LOAD * inline [

Region

North ];

[Anil_Babu_Samineni]

This is not the way to ask

Qlik Community Tip: How to Get Answers to Your Post

Or

Approach 1:

Load * Inline [

States

South

West

North

East

] Where State = 'North';

PS - I assume, You have field values not the field names.

Better to understand, Please mark as helpful so that we can look and continue from there Marks

[Anonymous]

without where clause i want to display north

[Vijen_M]

Well take a inline load and take your feild region and write only North and left join this table to your main table 

Table1:

load*inline[

Region

North

];

Left Join

Table2:

region:

LOAD

South,

North,

 West,

 east

FROM News;