topic Re: Exclude value from a dimension in QlikView

Exclude value from a dimension

alexantone — Fri, 27 Apr 2018 10:45:49 GMT

Hello

i want exclude a value with expresion like this on my dimension named Myvalue

if(mydate >=201802 and Myvalue <>'xxxxx' ,Myvalue) =>FINE OK

if(mydate >=201802 and Myvalue <>'xxxxx' ,Myvalue,i want here all my dimension without exclusion) =>FINE KO

but i cant' make an else condition it doesnt work fine

YoussefBelloum — Fri, 27 Apr 2018 11:16:13 GMT

Hi,

what is the logic behind filtering a dimension using an expression and use an else part to not filter that dimension ?

what is the exptected output ?

sasiparupudi1 — Fri, 27 Apr 2018 12:56:59 GMT

May be try

if(mydate >=201802 ,Only({<MyValue={'*'}-{'xxxxx'}>} Myvalue) ,MyValue)

alexantone — Fri, 27 Apr 2018 15:38:09 GMT

Thank for your return

But it doesn't work.

vishsaggi — Fri, 27 Apr 2018 15:58:35 GMT

Can you post some sample data to work on? And your expected output?