topic Display values selectively in pivot table in QlikView

Display values selectively in pivot table

Wed, 29 Dec 2010 09:53:31 GMT

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 ?

Display values selectively in pivot table

tresB — Wed, 29 Dec 2010 11:24:40 GMT

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

Display values selectively in pivot table

Thu, 30 Dec 2010 12:21:34 GMT

Is there any sample document for set analysis of Qlikview ?

Display values selectively in pivot table

tresB — Thu, 30 Dec 2010 12:52:26 GMT

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

Display values selectively in pivot table

Thu, 30 Dec 2010 14:59:11 GMT

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