topic Macro to hide Expression in QlikView

Macro to hide Expression

Thu, 17 Mar 2011 06:01:52 GMT

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

Macro to hide Expression

deepakk — Thu, 17 Mar 2011 06:32:42 GMT

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

Macro to hide Expression

Thu, 17 Mar 2011 06:48:39 GMT

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

Macro to hide Expression

deepakk — Thu, 17 Mar 2011 07:28:18 GMT

TRY out the application

Macro to hide Expression

Fri, 18 Mar 2011 03:58:01 GMT

Thanks Deepak,

It works i have Checked and Written macro .

Regards,

Pranav