topic Force table to show only specific value in QlikView

Force table to show only specific value

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

Hello,

I'm trying to show 2 identical tables on the same page, but each showing only specific data

In my example, my tables would look like this:

ID NAME TYPE DESCRIPTION

1 AAA LETTER This is a letter (A)

2 BBB LETTER This is a letter (B)

3 0123 NUMBER This is a number

I'd like these 2 tables to show specific result without the need to make a selection (as I need other tables to show all the datas)

TABLE 1: Show only TYPE=LETTER (without the need to click on LETTER in selection list)

ID NAME TYPE DESCRIPTION

1 AAA LETTER This is a letter (A)

2 BBB LETTER This is a letter (B)

TABLE 2: Show only TYPE=NUMBER (without the need to click on NUMBER in selection list)

ID NAME TYPE DESCRIPTION

3 0123 NUMBER This is a number

TABLE3: Show all values, depending on the selection(s) I make in the list

I tried to use condition >> if(Type='LETTER') but I don't get the result I need

Let me know if you need more details

Thank you for your help

Anonymous — Wed, 18 May 2016 01:36:24 GMT

Hi Fabien,

You could use set analysis or a calculated dimension to achieve this. Please check the attached qvw with some examples.

Hope it helps.

-- Karla

trdandamudi — Wed, 18 May 2016 02:17:18 GMT

One more way to do (Please see the attached):

I used the set analysis method in the attached file. You can also achieve this using Flag concept in the script.

fgirardin — Wed, 18 May 2016 08:09:21 GMT

Thank you both for your answers !

Both solutions are working for me, using a simple table.

I also have some more complex tables that contains more columns so I cannot use "Supress when value is null" as some value aren't null

Is there a way to completely hide rows that are not "TYPE=NUMBER", same way as if I would select only "Number" on a selection list ?

Thank you for your time

trdandamudi — Wed, 18 May 2016 11:39:09 GMT

Unless I misunderstood, It is the first chart in my application which shows the rows which are not equal to 'NUMBER'. See the screen shot below:

fgirardin — Fri, 20 May 2016 12:53:51 GMT

No it's OK, I was not really clear.

After modifying my chart I can use your solution, thank you

trdandamudi — Fri, 20 May 2016 13:05:16 GMT

Glad able to help you ...