Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
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

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?