Display values selectively in pivot table

[#1]

All the the records are available to pivot table, but need to display if the column values are beyond pre-determined threshold values.

How to restrict the display of records ?

[tresesco]

Hi,

Possibly you are talking about dimension values. If so, you can try "Calculated Dimension". Or even you can put the condition (using IF or Set Analysis or so) in the Expression of calculated column itself.

regards, tresesco

[#3]

Is there any sample document for set analysis of Qlikview ?

[tresesco]

Hi,

If you are new in Set analysis, you should go for "Help" study. Still i am attaching a sample application found from the forum itself for your better understanding.

regards, tresesco

[#5]

Hi mc22_qlik,

in addition to the post of tresesco here two simple examples for filtering records in the expression of a chart with an amount greater or equal 100:

sum( if( Amount >= 100, Amount, 0))

sum({< Amount= {'>= 100'} >} Amount)

HtH

Roland