topic Re: Restrictions syntax on dimension pivot table in QlikView

Restrictions syntax on dimension pivot table

Wed, 03 Jul 2013 21:32:14 GMT

hi i am trying to restrict some values in my pivot table.

however i seem to recieve null values in my result;

i have attached the application to show the behaviour.

is it possible to use if statements on Dimensions to restrict data?

Best,

Bradley

Re: Restrictions syntax on dimension pivot table

calvindk — Wed, 03 Jul 2013 23:04:03 GMT

Yes, you can add calculated dimensions based on if, such as IF(FieldName = 'XX', FieldName, NULL()) and then suppress nulls on that dimension.

However if it is a simple if expression like that, you would be better off adding a flag in your dataset and using that in your expressions as set analysis

Re: Restrictions syntax on dimension pivot table

CELAMBARASAN — Wed, 03 Jul 2013 23:04:48 GMT

Hi,

Check the Suppress When value is Null.

Regards,

Celambarasan