Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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
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.
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.
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:
No it's OK, I was not really clear.
After modifying my chart I can use your solution, thank you
Glad able to help you ...