Exclude the Value

[#1]

Hi,

I am having the data table which has some hundreds of the Customer Code. now we want to elminate some of the customer code from the Data table . We would like to have text box like feild and user can provide the customer code which has to be excluded from the data table.

Is it possible to do the same???

Regards,XXX

[#2]

Do you want to hide the Customer Code, remove it from a QV table, remove it from DB table or restrict access to it?

[#3]

Hi Nick

I want to hide the customer code from the QV Object (data table)

Regards,xxx

[#4]

I think if you add a calculated dimension solve your problem...did you try that?

[#5]

Hi ,

It should be done at runtime through the input box where as user can provide the Code which has to be excluded from the datatable.

Regards,XXX

[shumailh]

See the attachement, I couldnt do it perfectly by macro.. i think i am doing some mistake in it.

but i idid it through action triggers check the attachement,

Shumail

[#7]

Thanks Shumail,

By seeing your BAR Chart graph i have a query on BAR Chart x Axis. In my BAR chart i have displayed the text in the slanting format as you have done. but the text is getting truncated due to the number of characters. is there any way i can warp the text and display it in the X Axis

regards,XXX

[#8]

I would avoid any macro if it's possible. You can do something like this.

[#9]

Thanks for your response Nick.

I am trying in vice versa of your example. By default all the data will be displayed and based on the selection the data will be excluded and displayed...

regards,XXX

[#10]

Nothing can be easier then. See the vice versa logic in attachment.