topic Re: Hide Row names from view? in QlikView

Hide Row names from view?

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

I was hoping someone could help me to hide names in a row without losing the data

For example I only want to show "Martin" but not lose the rank or result

example table:

Name Rank Result

Martin 1 80%

James 2 76%

Paul 3 75%

I am hoping the result will look like the below

Name Rank Result

Martin 1 80%

2 76%

3 75%

Thank you in advance

Re: Hide Row names from view?

Miguel_Angel_Baeyens — Wed, 23 May 2018 07:03:11 GMT

The solutions by Stefan will likely help:

Get max cell value of all rows and columns

Re: Hide Row names from view?

olivierrobin — Wed, 23 May 2018 07:03:50 GMT

hello

you can code an expression to display/hide value on condition

-> but what is the condition ?

suppose it's rank, you could write in expression

if(Rank=1,Name,' ')

Re: Hide Row names from view?

Anonymous — Wed, 23 May 2018 07:06:10 GMT

it would be based on the name

There are about 6 tables where the rank would be different for each person

Thank you

Re: Hide Row names from view?

Anonymous — Wed, 23 May 2018 07:08:42 GMT

Ahhh school boy error

If I select the name it filters the results anyway making "Martin" rank 1 in all tables

Re: Hide Row names from view?

olivierrobin — Wed, 23 May 2018 07:12:57 GMT

but the goal is not to select ?

if it is based on a list of names, and this list is stored somewhere, you can left join this list with your data, and create a flag

in your graph, you write a condition based on the value of this flag

Re: Hide Row names from view?

Anonymous — Wed, 23 May 2018 07:21:19 GMT

No not really

the names in the example represent a manufacturer - I have grouped the companys into the main parent group and used a selection box to limit the results to the top 5

but I don't want to show all results to all companys so to add in an additional layer to hide 4 of the 5 would be the preferred option (more of a view filter than an actual data one)

I hope this makes sense

Re: Hide Row names from view?

olivierrobin — Wed, 23 May 2018 07:28:10 GMT

if you can write an if condition, you can hide them

Re: Hide Row names from view?

Anonymous — Wed, 23 May 2018 07:29:59 GMT

Hi Johnson,

In Expression you can check Firstsortedvalue(Name) using this you will get only selected name other fields will come as usual.

Thanks Regards,

Ramesh.P

Re: Hide Row names from view?

Anonymous — Wed, 23 May 2018 07:37:30 GMT

I would tell you the procedure which i have followed for resolving your query

Step 1: In the data manager edit the sheet where your data is present

Step 2: click on select nulls and select paul and James and set them as 'set nulls'

Step 3: when you create an infographic you get the visualization the way you mentioned in your query.

Hope this helps

Re: Hide Row names from view?

Anonymous — Wed, 23 May 2018 07:38:26 GMT

‌is there some way of creating variable buttons to achieve this ?

Re: Hide Row names from view?

olivierrobin — Wed, 23 May 2018 07:44:03 GMT

write your condition depending on a variable

and create button(s) to set this variable to the value you want

Re: Hide Row names from view?

Anonymous — Wed, 23 May 2018 17:09:52 GMT

‌Hi Konka

is this available in qlikview 11 or 12?

Re: Hide Row names from view?

Anonymous — Thu, 24 May 2018 08:03:31 GMT

Hi Olivier

Do you have an example of this I could see please

Thank you in advance

Martin

Re: Hide Row names from view?

olivierrobin — Thu, 24 May 2018 09:05:16 GMT

hello

you can create buttons in which you assign a value to a variable

and in you graph, in expressions you code a if(variable=,,) to display one value or another

Re: Hide Row names from view?

Anonymous — Thu, 24 May 2018 09:16:13 GMT

Hi Martin,

Otherwise in table box you can write Expression as =sum({$},Name) This is for current selection names

other fields you add directly Rank and Result. Just try it and let me know.

Thanks Regards,

Ramesh.P