Force table to show only specific value

[fgirardin]

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]

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 · Accepted solution]

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]

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

F.

[trdandamudi]

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]

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

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

[trdandamudi]

Glad able to help you ...