topic Re: Show Expressions on a Table in QlikView

Show Expressions on a Table

microwin88x — Tue, 13 May 2014 21:04:46 GMT

Hello!

I need to create the following table:

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 — Tue, 13 May 2014 21:09:48 GMT

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

Enable option 'horizontal' on presentation tab.

ankitaag — Tue, 14 Apr 2015 10:48:43 GMT

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 — Tue, 14 Apr 2015 11:15:22 GMT

Hello again,

Please check the attached qvw for the result.

Hope this is helpful.

Thanks and Regards

Ankita