topic Re: filter in QlikView

filter

satishqlik — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I need to hide the field value from the filter and I have tried by using below expressions

If use below expression,

=Aggr(Only({<Yardstick={'MTH'}>}Yardstick),Yardstick)

by visibility it is not showing but If select any value from Yardstick we could see MTH

also tried with

If(not Match(Yardstick,'MTH'),Yardstick) it gives me like below

This is fine but it is not showing the field name as same as shown in the above snapshot.

any suggestions will be appreciated.

Thanks,

PrashantSangle — Fri, 06 Jul 2018 08:18:23 GMT

why dont you create that field in back end.

Regards,

PrashantSangle — Fri, 06 Jul 2018 08:24:06 GMT

or You can try master item. Create that calculated field in master item and then use that field in front end.

Regards,