Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Not applicable

The dumbest question ever// La pregunta más tonta

Hi, everyone!

I need help... I need to exclude values with '*' in it. I tried with '*' and "*", but it was useless...

Any ideas?

Thanks in advance!!!

_________________________

Hola, gente!

Necesito ayuda.. Necesito excluir valores que tengan asterico en el campo, probé con '*' y con "*", pero no funcionó.


Alguna sugerencia?

GRACIAS!!!!!!!!!

4 Replies
Highlighted
MVP
MVP

Re: The dumbest question ever// La pregunta más tonta

Using set analysis?

Maybe like

{<FIELD -= {"=Index(FIELD,'*')"}>}

Highlighted
Not applicable

Re: The dumbest question ever// La pregunta más tonta

I was trying to get rid of the values at loading....

Highlighted
MVP
MVP

Re: The dumbest question ever// La pregunta más tonta

Maybe

LOAD

....

FROM ....

WHERE INDEX(FIELD,'*')=0;

Highlighted
Not applicable

Re: The dumbest question ever// La pregunta más tonta

IT WORKED PERFECTLY!!!! THANKS!!!