Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
nishanthi_8
Not applicable

How to create a filter where the particular column doesnt exist?

I dont have a column called status which consists of whether the employee has been assigned or not - assigned to Project. But i explicitly want to create a column from script side as Status - Assigned / Not - Assigned as a filter and once it is selected the Particular name should be displayed. How it can be achieved? I tried with the mapping load it gives the names of assigned. But I dont want in that case. Instead i want the filter to contain to assigned and not assigned and based on that selection particular name should be displayed.

5 Replies
balrajahlawat
Not applicable

Re: How to create a filter where the particular column doesnt exist?

Create a inline field like this:

Load * Inline

[Status

Assigned

Not Assigned

];

Use it as a filter at front end and make the data conditional to display

nishanthi_8
Not applicable

Re: How to create a filter where the particular column doesnt exist?

any other alternative method ?

balrajahlawat
Not applicable

Re: How to create a filter where the particular column doesnt exist?

I think Inline is the best option for same

Not applicable

Re: How to create a filter where the particular column doesnt exist?

Or if you can write IF condition in your script: IF(cond, 'Assign','Not Assign') As Status

oscar_ortiz
Not applicable

Re: How to create a filter where the particular column doesnt exist?

You can try an if statement in your script.

Something like:

If( [ Your Condition], 'Assigned', 'Not Assigned' ) as Status