Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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';
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
I just want to load those customer name who are active.
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';
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;
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.
Thank you so much everyone