Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Become an analytics expert with Qlik's new 15 week course: Applied Data Analytics using Qlik Sense. READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Display only those customer who is active without any selection

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

1 Solution

Accepted Solutions
MarcoARaymundo
Creator III
Creator III

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

View solution in original post

6 Replies
Not applicable
Author

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

Not applicable
Author

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

MarcoARaymundo
Creator III
Creator III

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

View solution in original post

Not applicable
Author

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
Luminary Alumni
Luminary Alumni

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.

Not applicable
Author

Thank   you so much everyone