topic Re: Only show certain value in QlikView

Only show certain value

Anonymous — Wed, 20 Jul 2016 14:57:36 GMT

Hi All,

I need help with an expression. I'm working on a dimension called "Level" and I just want to show where Level = 2 and exclude the rest of the Levels. I can do this by selection but I want to hard coded to just Level=2.

I tried with Only(Level)=2, it didn't works. Any suggestions greatly appreciated!!!

Frank

Re: Only show certain value

sunny_talwar — Wed, 20 Jul 2016 15:05:14 GMT

May be this as your calculated dimension

If(Level = 2, Level) and check 'Suppress When Value Is Null'

or use this as set analysis within your expression

{<Level = {2}>}

Re: Only show certain value

danansell42 — Wed, 20 Jul 2016 15:06:44 GMT

If you wanted to populate a list box with just Level 2 then you could use the expression function with something like:

=if(Level=2,Level)

This would then just give you a list box with that value.

If you wanted to code a chart/table to only display values filtered for Level 2 then use set analysis.

Example: SUM( {<Level= {2} >}Sales

Thanks

Dan

Re: Only show certain value

trdandamudi — Wed, 20 Jul 2016 15:08:10 GMT

You can do in two ways:

Option I:

Create a calculated dimension as If(Level=2,Level)

and make sure you put a checkmark against "Suppress when value is null"

Option I:

Dimension: Level

Expression: {<Level={2}>}Amount

Note: Please replace the field Amount with appropriate field in your table.

Hope this helps.

Re: Only show certain value

Anonymous — Wed, 20 Jul 2016 15:30:43 GMT

All,

All your responses works. Thank You!

Re: Only show certain value

jmialoundama — Thu, 01 Feb 2018 10:04:38 GMT

Hello

I have a table and i want to show only two values "eLiqudie" and "Materiel" :

When i use the function ONLY, it's work : =AGGR(ONLY({$<[Cd. Univers (ref)]={'83','88'}>} [Lib. Univers (ref)]), [Lib. Univers (ref)])

But when i use function ONLY in clause if results which obtain it's false :

= if($(vELiquide)=10,

AGGR(ONLY({$<[Cd. Univers (ref)]={'83'}>} [Lib. Rayon (ref)] ),[Lib. Rayon (ref)])

AGGR(ONLY({$<[Cd. Univers (ref)]={'83','88'}>} [Lib. Univers (ref)]), [Lib. Univers (ref)])

)