topic Re: hide values in QlikView

hide values

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

How to hide the fileds in a list box without getting Spaces

Re: hide values

Clever_Anjos — Wed, 27 Jul 2016 13:37:02 GMT

Could you elaborate a bit more your need?

Re: hide values

sonysree88 — Wed, 27 Jul 2016 14:04:14 GMT

Hello Am attaching my QVW file here can you please check and give me the answer with screenshots why because i am using Personal edition i am unable to open if you can change and send it to me back..

Here in the sheet taken one list box with Agent name filed

If i can select Damon name in that listbox i want to display only that value reaming should be hidden !

Re: hide values

beck_bakytbek — Wed, 27 Jul 2016 14:11:22 GMT

Hi sonygot,

in the case of listbox: you can use in properties: General, Field:<Expression> in Expression you can add your requirements.

to fine the better solution for your Problem, give more Information to your case/issue.

beck

Re: hide values

vishsaggi — Wed, 27 Jul 2016 14:23:06 GMT

Your QVW file you sent already works the way you want. It hides the other field values when you select any value. What the error or output you are looking for can you send us a screen shot or explain little more please....?

Re: hide values

sonysree88 — Wed, 27 Jul 2016 14:25:18 GMT

when you are click on Damon in that list box it should only display reaming should be hidden

Its my requirement..

When i enable hide excluded in General tab of properties of Listbox.It will work but spaces are coming

Re: hide values

Colin-Albert — Wed, 27 Jul 2016 14:28:20 GMT

You need to review your data model as you have created 4 sets of data which are not linked to each other.

so a selection on Agent will have no affect on the Policy or Client data.

Re: hide values

maxgro — Wed, 27 Jul 2016 14:29:02 GMT

maybe with an expression

=Aggr(Only([Agent Name]), [Agent Name])

Re: hide values

Colin-Albert — Wed, 27 Jul 2016 14:32:11 GMT

This is how list boxes are designed to work. List boxes are filter lists that update the selected range of data displayed in your application. Turn off the "Hide Excluded" option and you will see the selections you have chosen highlighted in Green, White and Grey.

Green Is the Colour

Qlik Tips: Raise a flag to the Green, White and Gray

Re: hide values

Frank_Hartmann — Wed, 27 Jul 2016 14:38:14 GMT

why not using a straight table with "Agent Name" as dimension and "1" as Expression, then on Presentation Tab you can hide the expression column and you have the required behaviour!

hope this helps

Re: hide values

Wed, 27 Jul 2016 14:40:24 GMT

Hi Sony

You can check this option " Hide Excluded " .

Re: hide values

sonysree88 — Wed, 27 Jul 2016 14:44:38 GMT

Hi Maxro,

Its working fine am looking for this Answer only..

Thanks for you help

i have One more question is here ; how to add any symbols like $#% for the entire Agent name filed ..

Appreciate if you can help to this question too.

Regards

Sonysree

Re: hide values

Colin-Albert — Wed, 27 Jul 2016 14:53:03 GMT

If Maxgro gave you the correct answer, you should mark his answer as correct not your own!

Re: hide values

Wed, 27 Jul 2016 14:54:54 GMT

Agreed ..

Re: hide values

vishsaggi — Wed, 27 Jul 2016 14:59:27 GMT

I am not sure if this is what you want?

In Maxgro's expression add like:

=Aggr(Only([Agent Name]) & '#', [Agent Name])

Re: hide values

sonysree88 — Wed, 27 Jul 2016 15:11:26 GMT

Yes am looking to this only but here when am applying the above expression ,Symbols are coming seperated values in that lisbox ,How to delete this one..

Except hide excluded option

Re: hide values

vishsaggi — Wed, 27 Jul 2016 15:21:31 GMT

IN the expression tab Add

= '$12#'

And Alignment to left.