Macro to hide Expression

[#1]

Dear All,

Can Any one Suggest me how to hide the column on based on selected fields.

Example :

I am having a Check box with 4 Fields, FT, MT, CBM, TEU

If i click on Any of this Fields then that Expression Expression Should be Visible in Straight or Pivot Table, i e, if i click on FT Ft Expression should be vissible.

I am Using QlikView Version 8.5.

9.0 its Easy through Straight table Conditional Hide but i have to do it in 8.5 as per User Preference.

Please Kindly Help me.

Regards,

Pranav

[deepakk]

hi Pranav,

I think we just need to add the dimension as in cross format and hence when ever the user selects from the list box he will be able to see onlt that data.

I have also add a macro code, but i dont think we need that but still you can go through the application

[#3]

Dear Deepak,

Thanks for Reply, but in yourSample aplication only the Dimension is Changing but the Expression is one only,

Fro me Dimension Should not do any thing i have to hide Expressions i have 10 Expressions.

If you get any idea how to do it please Suggest Soon.

Regards,

Pranav

[deepakk · Accepted solution]

TRY out the application

[#5]

Thanks Deepak,

It works i have Checked and Written macro .

Regards,

Pranav