Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
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
Highlighted
MarcoARaymundo
Contributor III

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

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
Highlighted
Not applicable

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

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

Highlighted
Not applicable

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

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

Highlighted
MarcoARaymundo
Contributor III

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

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

Highlighted
Not applicable

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

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;

Highlighted
MVP & Luminary
MVP & Luminary

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

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.

Highlighted
Not applicable

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

Thank   you so much everyone