Display only those customer who is active without any selection

[#1]

Hello everyone,

I  am new to qlikview,I  have assigned a task with a query 'display only those customer who is active without any selection'.

I am not able to understand where I put the condition to display the active customer,there are two values in Account status 1)Active 2)Disconnected.

The load statement is

LOAD Id as [Customer Account],

           [Customer Name],

           [Account Number],

           [Account Balance],

           Status as  [Account Status]

FROM

[..\data files\csvs\CustomerAccount.csv]

(txt, codepage is 1252, embedded labels, delimiter is ',', msq);

Please help me out. Thank u

[#2]

I understand, that you want to load al customers, but in application show some values (for example Account Balance) only for active customers.

If yes, you may use set analysis.

expression like this:

sum({<[Account Status]={2}>}[Account Balance])

should do it in the chart.

Regards

Darek

[#3]

I just want to load those customer name who are active.    

[MarcoARaymundo · Accepted solution]

Hi

Try this

LOAD Id as [Customer Account],

           [Customer Name],

           [Account Number],

           [Account Balance],

           Status as  [Account Status]

FROM [..\data files\csvs\CustomerAccount.csv] (txt, codepage is 1252, embedded labels, delimiter is ',', msq)

WHERE Status = 'ACTIVE';

[#5]

this should work:

LOAD Id as [Customer Account],

           [Customer Name],

           [Account Number],

           [Account Balance],

           Status as  [Account Status]

FROM

[..\data files\csvs\CustomerAccount.csv]

(txt, codepage is 1252, embedded labels, delimiter is ',', msq);

Where Status=2;

[jagan]

Hi,

Try like this

Data:

LOAD Id as [Customer Account],

           [Customer Name],

           [Account Number],

           [Account Balance],

           Status as  [Account Status]

FROM

[..\data files\csvs\CustomerAccount.csv]

(txt, codepage is 1252, embedded labels, delimiter is ',', msq)

Where Status = 'Active';

Regards,

Jagan.

[#7]

Thank   you so much everyone