Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
cancel
Showing results for 
Search instead for 
Did you mean: 
sweens78
Creator
Creator

Hide a field in a dimension

Hi Guys,

I have a chart below and I want to hide one of the fields in the dimension, any ideas, I know you can do it on a table but how on a chart?

6 Replies
andrey_krylov
Specialist
Specialist

Maybe editing expression

=if( not ThisField like 'Currently atten*', ... )

or set analysis {< ThisField -= {'Currently atten*'} >}

vitaliichupryna
Creator III
Creator III

Hi,

You can use set analysis. For example:
sum({<Category -= {"Currently"}>}Sales)
This expression will show sum of sales for all categories except of "Currently"

Thanks,
Vitalii

sweens78
Creator
Creator
Author

Hi Andrey should it be the a edited Dimension I nned to add rather than expression?

I tried the first code but getting errors?=if( not ThisField like 'Currently atten*', ... )

raman_rastogi
Partner
Partner

Try this

Calculated dimension


if (dim='value',' ',dim)

and Suppress null values for dimension.

Regards

Raman

rajivmeher
Creator
Creator

Hi Martin

Have you tried puting the following condition in dimension?

IF(Field_Name <> 'Currently atten'(please mention the full value here), Field_Name)


You can go into dimension tab, select the dimension and edit it. Add the above expression and see if the dimension value gets hidden in the chart?


Regards

Rajiv.

andrey_krylov
Specialist
Specialist

This can be both an expression and a dimension, as suggested by Raman and Rajiv. You need to determine what field is used in the chart and put it in the formula.

1. Dimension:  = if ( field <> 'Currently atten...', field )

            'Currently atten...' -   this value must be completed. And Suppress null values


2. Expression: to the used expression add this condition, for example

          sum( if ( field <> 'Currently atten...', Amount ) )

          or in set analysis  sum( {< field -= {'Currently atten...'} >} Amount )