topic Re: Data Load in QlikView

Data Load

Thu, 12 Jul 2012 18:29:17 GMT

I am loading data in qlikview

Load

Domain,

SubDomain,

Visits

from.............

where Domain<>'total' and SubDomain='total';

from attached excel sheet

but in this way i m not able to load data of Domain xyz,jkl

i want to load data with xyz and jkl is there any way to load that.

this is a sample data i have more than 100000 rows.

Re: Data Load

MayilVahanan — Thu, 12 Jul 2012 19:10:08 GMT

Hi,

Try this,

Test:
Load if(SubDomain = 'total',SubDomain) as DomainSubstitute, * from.............where Domain<>'total';

(or)

Test:
Load if(SubDomain = 'total',SubDomain) as DomainSubstitute, * inline
[
Domain,SubDomain,Visit
abc,abc1,10
abc,abc1,10
abc,abc1,10
abc,abc1,10
,total,50
xyz,total,20
ghj,ghj1,30
ghj,ghj1,30
ghj,ghj1,30
ghj,ghj1,30
,total,120
jkl,total,80
total,total,430
]where Domain<>'total';

Drop Field SubDomain;

Hope it helps

Re: Data Load

Thu, 12 Jul 2012 19:24:14 GMT

is there any way so that i can load total of SubDomain when count of Domain is =1or resitrict

total rows of sub domain where count of domain >1

above solution not working in this case.

Re: Data Load

Thu, 12 Jul 2012 19:39:07 GMT

or there is any way so that i load all data with condition Domain<>'total'

and give expression to add visit for total where domain is not null

or exclude where Domain is null so that i get overall total 430 as attached in excel

Re: Data Load

MayilVahanan — Thu, 12 Jul 2012 19:43:42 GMT

Hi,

Do you want to remove Domain not equal to total and null value..am i correct?

If So,

Try this,

Test:

Load if(SubDomain = 'total',SubDomain) as DomainSubstitute, * from.............where Domain<>'total' and Len(Trim(Domain)) > 0;

Just want to satisfy above condition,

Use like this

Test:

Load * from.............where Domain<>'total' and Len(Trim(Domain)) > 0;

Hope it helps..