Show Expressions on a Table

[microwin88x]

Hello!

I need to create the following table:

Observations	10
Periods	15
Complaints	3
Inspections	8

The thing is that Observations/Periods/Complaints/Inspections are expressions. For example, Observations is the following expression:

COUNT ({$<ID_TIME_DATE#={">=$(='$(vDateFrom)')<=$(='$(vDateTo)')"}>} DISTINCT OBSERVATIONS)

An so on with the other expressions.

So I wanted to know if is there any way to create a table or what object could I use to show that information.

Or shoud I have to add those expressions to a dimension?

Thank you!!!

---

Then I'd need to see (maybe as a Pivot Table) for my expression Observations, the ACCOUNT_ID that have Observations

[swuehl]

Just create a straight table with your four expressions, no dimension.

Enable option 'horizontal' on presentation tab.

[ankitaag]

Hello Micro,

Do you have these for options as 1 column or different columns?

Or can you please provide some sample data so as to come up with the best solution.

Thanks and Regards,

Ankita

[ankitaag · Accepted solution]

Hello again,

Please check the attached qvw for the result.

Hope this is helpful.

Thanks and Regards

Ankita