topic Re: Display only those customer who is active without any selection in QlikView

Display only those customer who is active without any selection

Thu, 15 May 2014 13:31:21 GMT

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

Re: Display only those customer who is active without any selection

Thu, 15 May 2014 13:43:13 GMT

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

Re: Display only those customer who is active without any selection

Thu, 15 May 2014 13:46:54 GMT

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

Re: Display only those customer who is active without any selection

MarcoARaymundo — Thu, 15 May 2014 13:52:01 GMT

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';

Re: Display only those customer who is active without any selection

Thu, 15 May 2014 13:54:38 GMT

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;

Re: Display only those customer who is active without any selection

jagan — Thu, 15 May 2014 14:06:36 GMT

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.

Re: Display only those customer who is active without any selection

Thu, 15 May 2014 16:49:23 GMT

Thank you so much everyone