topic Dimension Limits in QlikView

Dimension Limits

Thu, 21 Nov 2013 06:10:03 GMT

Hi all,

I had a dimension which had follwing fields in it

Bag,

Bulk,

Box,

cement.

I wanna use this dimension in a pivot table . Then it should show only Bag and Bulk excluding Box and Cement.

Please help me in writing a calculated dimension for this.

Thanks in advance.

Regards,

Susvith

kaushiknsolanki — Thu, 21 Nov 2013 06:14:53 GMT

Hi,

Are this a field, or a field value?

If they are field value of say field 1 then try below.

=if(wildmatch(Field1,'Bag','Bulk'),Field1)

And if they are field then use the conditional Enabling option.

Regards,

Kaushik Solanki

Thu, 21 Nov 2013 06:18:47 GMT

thanks ....

Its working

Regards,

Susvith