Solved: Dimension Limits - Qlik Community

Report Inappropriate Content · ‎2013-11-21

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 · ‎2013-11-21

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

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!

kaushiknsolanki · ‎2013-11-21

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

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!

Report Inappropriate Content · ‎2013-11-21

thanks ....

Its working

Regards,

Susvith

Dimension Limits