Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Straight Table Chart 1
Dimensions: Expression:
Fruits ID
Vegetables
Drinks
Fish
Meat
Straight Table Chart 2
Dimension: Expression
ID Only({<ID = >} Fruits)
For both tables the result would be similar, something like (Results based on selections):
ID | Fruits | Drinks | Vegetables | Fish | Meat |
---|---|---|---|---|---|
1 | Apple | D1 | Potatoes | Salmon | Lamb |
2 | Banana | D2 | Onions | - | Beef |
3 | Pineapple | D3 | - | - | Chicken |
4 | Watermelon | D4 | - | - | - |
5 | Melon | D5 | - | - | - |
6 | - | D6 | - | - | - |
Now I was asked to present the Totals on the Last Row, the expected result should be:
6 | 5 | 6 | 2 | 1 | 3 |
Problem:
In the first chart in the expression I just had to use the Total Mode (Numeric count). But when I go to the presentation tab to use the TOTALS option (Total on Last row with label =GetPossibleCount(Fruits) ), it only works for the first dimension (It applies the result for the all rows):
6 | 5 |
Is there a way for me to count the results on the chart or get the expected requirement?
Thanks in advance for your help.
Regards,
Iuri
Hi , since the level place is not a kind of writing the expression so it will not work as expected.
its not a good idea but we can take a text box at the place where you want the count for desired one
and use count(fruits) and keep the the text object at the same place by matching all color combination same.
Hi Rajesh,
Thank you for your response. I think that only way will be to create the same chart (with condition) then insert expressions with count.
Use this. !
It is working. I have tested it.
Hi Hemantha,
Thank you for your help, was good learn this from you!
Hi Hemantha,
when i select any id from your application then i get wrong count. Are you sure is this the wright answer.
Hi Vipin,
I have applied the same logic in my main QVW and its working fine, you may have to look on the total mode options.
I forgot to mention that I removed the "-1"