Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Attend QlikWorld 2020 and hear keynote speaker, Malcolm Gladwell. $300 savings extended to February 9th Learn More
choijunghoon
New Contributor

How to disappear especail name in field in demisions.

Hi

I want to see the only “Missing” field in the table.

How to script in dimension ?

I can’t use filter there are many columm.

2.png

Tags (1)
2 Replies
choijunghoon
New Contributor

Re: How to disappear especail name in field in demisions.

Sorry How to appear defined name in field in deminstion?

Re: How to disappear especail name in field in demisions.

Hi, I'm not sure of your needs:

- To show this value as dimensión, the same expression can be used.

- If you want to show the text 'Missing' in the table you can try:

If(Detect='Missing', Detect)

- If it's about the column title, there is an option in the properties panel to set the label, if it's a master item it should be changed in the master item label property.

- If you want to show only the recors with values in this column, you should add this calculation as dimension and uncheck the option to include null values.