Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
franckwhite17
New Contributor II

delete some fields

how can I delete the% Dim_Calendrier_dkey fields to the month fields.

NB: these fields come from $ field which is the system field.

thank you for yours reactions.

9.PNG

Tags (1)
9 Replies
MVP
MVP

Re: delete some fields

Drop Field ...

What criteria are you using to select those fields? Do you want to remove them from the view/list, or do you want completely remove them from the document?

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
YoussefBelloum
Esteemed Contributor

Re: delete some fields

Hi,

try this:

=if(Left($Field,1)<>'%',$Field)

veerendrakatika
New Contributor III

Re: delete some fields

you want to hide with the prefix of % fields?

olivierrobin
Valued Contributor II

Re: delete some fields

hello

maybe

delete field ....

from table

franckwhite17
New Contributor II

Re: delete some fields

i want to remove from the view/list.

franckwhite17
New Contributor II

Re: delete some fields

I use them elsewhere so I can not delete from table

franckwhite17
New Contributor II

Re: delete some fields

it is not work...what is the syntax and where i can apply that.

franckwhite17
New Contributor II

Re: delete some fields

that's what it gives, it creates a second identical column12.PNG

sasiparupudi1
Honored Contributor III

Re: delete some fields

Try tag

Tag Fields Annee,annee,Date with '$hidden';