topic Exclude the Value in QlikView

Exclude the Value

Tue, 27 Jul 2010 13:27:34 GMT

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

Exclude the Value

Tue, 27 Jul 2010 13:53:05 GMT

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

Exclude the Value

Tue, 27 Jul 2010 14:02:15 GMT

Hi Nick

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

Regards,xxx

Exclude the Value

Tue, 27 Jul 2010 14:12:58 GMT

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

Exclude the Value

Tue, 27 Jul 2010 14:29:44 GMT

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

Exclude the Value

shumailh — Tue, 27 Jul 2010 14:39:32 GMT

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

Exclude the Value

Tue, 27 Jul 2010 14:51:00 GMT

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

Exclude the Value

Tue, 27 Jul 2010 15:04:13 GMT

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

Exclude the Value

Tue, 27 Jul 2010 15:34:27 GMT

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

Exclude the Value

Tue, 27 Jul 2010 16:55:58 GMT

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

Exclude the Value

shumailh — Wed, 28 Jul 2010 07:00:38 GMT

Hey XXX,

I was away that's why couldn't reply... yes you can display the truncated text... try making them bold. i mean change the font of x axis data to bold. I know this is something strange but it works for me...

Shumail

Exclude the Value

Wed, 28 Jul 2010 07:31:44 GMT

Thanks Shumail ,

I will try that and update you

Hi Nick,

Thanks for your response

I have a doubt on the calculation you have done for excluding the selected values. As you have two columns as Code ,Exclusion code with same values and through Match and getfeildselcetion value you have excluded. But i am trying to do the same thing with the siongle column. Since our data is of huge size it is like we need to add one more column to exclude the values.

This is the code i am trying .. Please correct me if i am wrong.

=IF(match(CID,$(=GetFieldSelections(CID,',')))=0,CID)

Is it mandatory that we need two columns with different names or is there any functionality to achieve this.

Also what is the use of the Select Excluded. I have tried using the select excluded . but while exporting to excel the excluded value is also getting exported.

Regards,XXX

Exclude the Value

Wed, 28 Jul 2010 13:21:52 GMT

Check my last attachment. There is an implementation with one field.

Exclude the Value

Wed, 28 Jul 2010 13:47:24 GMT

Thanks for response Nick,

I have some doubt ...

In your first example when you select the excluded code then the other table data is getting displayed based on the exclusion/excluding the selected values.

Since it is not mandatory we need to exclude the values. So by default the value should get displayed in the table and when they choose the excluded values then table data should get changed accordingly.

I have tried the Search excluded Built in option. Can u please explain this functionlity if feasible.....

Regards,XXX