Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
jvk_sharma
Creator III
Creator III

How to stop the "Test Service" coming onto the table.

Hi,

I have data coming from the database which has got both Live services and Test service.

How Can I stop the data coming onto the Table.

This is the code I have been using but still showing the Test data.

services:

LOAD id AS service_id,

   name AS service_name,

SQL SELECT id,

    name

FROM "myhealth_production"."public".services;

services.png

Any help pls.

1 Solution

Accepted Solutions
adamdavi3s
Master
Master

LOAD id AS service_id,

   name AS service_name,

SQL SELECT id,

    name

FROM "myhealth_production"."public".services

WHERE name not like '%test%';

???

View solution in original post

6 Replies
buzzy996
Master II
Master II

u can try with simply if expression,if ur fieldname='testservice',null(),fieldname;

adamdavi3s
Master
Master

LOAD id AS service_id,

   name AS service_name,

SQL SELECT id,

    name

FROM "myhealth_production"."public".services

WHERE name not like '%test%';

???

jvk_sharma
Creator III
Creator III
Author

nope it is still getting Test.

adamdavi3s
Master
Master

Is it coming in elsewhere in your data model then?

jvk_sharma
Creator III
Creator III
Author

Thanks Adam.

It worked now.

much appreiciated.

adamdavi3s
Master
Master

Excellent, glad you are sorted