Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Not applicable

Single column need to expose for adhoc reporting from aggregate table


In database we have aggregated sales value at different geography level. I'm pulling data like sales at geo hierarchy1,sales at geo hierarchy2 ans so on. Concatenating all the aggregated table and getting multiple sales columns at diff. geo hierarchy level for adhoc reporting. Is there any way we can expose only single sales column which will be driven autometically based geo hierarchy selection.

Tags (1)