Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikView forum consolidation is complete. Labels are now required. LEARN ABOUT LABELS
cancel
Showing results for 
Search instead for 
Did you mean: 
aaronnayan
Creator III
Creator III

script help

Hi Guys

I am in the script editor and loading a table file with fields. i only want data to load with certain values based on one of the fields conditions.

Custno

Flag4

i want all customers to load that Flag4 = Y  (yes)

I did think to put a where clause but it is not working unfortunately

Sorry this may sound confusing, please ask if you need more info i am really struggling

Many Thankssss

2 Replies
Peter_Cammaert

Maybe:

Table:

LOAD *

FROM TableFile (options)

WHERE UPPER(Flag4) = 'Y';

Anil_Babu_Samineni

May be missed Single Quote like Where Flag = 'Y'

Or else you could share full screen

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)