Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Adhoc Reporting

i have made a Adhoc report in which i have given Dimension and Measure metrices

Dimension like

year

month

quarter

Customer

Division

Country

city etc

Measure

Sales

Collection etc

Now i want to add one more filter for metrices Say SUM, AVG, COUNT etc

Example:

Year        Sales

2011        1000

2012         2000

2013         3000

2014         4000

Now If any user select say SUM then it should give me following adhoc report:

Example:

Year                Sales

2011               1000

2012               2000

2013               3000

2014               4000

Total SUM       10000

Similar for AVG, Count etc

Pls suggest.

3 Replies
ashfaq_haseeb
Champion III
Champion III

Hi,

check this

http://community.qlik.com/docs/DOC-5404

Regards

ASHFAQ

perumal_41
Partner - Specialist II
Partner - Specialist II

Hi

PFA,I  thing it help

fkeuroglian
Partner - Master
Partner - Master