Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
FLASH SALE: Save $500! Use code FLASH2026 at checkout until Feb 14th at 11:59PM ET. Register Now!
cancel
Showing results for 
Search instead for 
Did you mean: 
alexantone
Creator
Creator

Exclude value from a dimension

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

Labels (1)
4 Replies
YoussefBelloum
Champion
Champion

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
Master III
Master III

May be try


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

alexantone
Creator
Creator
Author

Thank for your return

But it doesn't work.

vishsaggi
Champion III
Champion III

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