Adhoc Reporting

[Anonymous]

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.

[ashfaq_haseeb]

Hi,

check this

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

Regards

ASHFAQ

[perumal_41]

Hi

PFA,I  thing it help

[fkeuroglian]

Hi

see this, hope helps

Fernando

QlikView

Qlik Demos: See QlikView in Action | Demo.Qlik.Com