topic Adhoc... in QlikView

Adhoc...

Anonymous — Thu, 14 Aug 2014 06:47:40 GMT

CAN we create a chart creation wizard functionality via Adhoc query....

Re: Adhoc...

sujeetsingh — Thu, 14 Aug 2014 06:48:53 GMT

I do not think this can be done.

Re: Adhoc...

tresB — Thu, 14 Aug 2014 06:49:07 GMT

This? Adhoc reporting in Qlikview

Re: Adhoc...

Anonymous — Thu, 14 Aug 2014 07:06:20 GMT

Actually there was a requirement of migrating reporting from Cognos to Qlikview,

and users were having flexibility in Cognos to build their own report on adhoc basis...

Thats why I was looking into these points....

Regards

Nitin

Re: Adhoc...

tresB — Thu, 14 Aug 2014 07:10:38 GMT

Assuming that, you are talking about allowing users create their own report using browser client, you can achive upto some extend in the IE by allowing 'Server Object' both in server as well as in document.

Re: Adhoc...

martijn — Thu, 14 Aug 2014 07:19:28 GMT

Shoot! tresesco allready posted an example...

Create an inline table with all the possible dimension values.

Create an table with all de dimensions and put an conditional show on them. Something like: =Substringcount(Concat(GetFieldSelections(_SelectionDimension), '|') ,'DimensionValue1’)

When the end users selects an dimension from the inline table, the dimension is shown. All the other dimensions are hided. You can do the same for measures.

This is in my opion the clossest call to adhoc reporting in QlikView

Re: Adhoc...

Thu, 14 Aug 2014 07:21:50 GMT

Yes.. Ad Hoc Reporting is possible.

Re: Adhoc...

Anonymous — Thu, 14 Aug 2014 09:03:47 GMT

Minor measures can be made as of simple aggregation ,

but while comparitive analysis, how it can be done, as users dont know set analysis.

While in cognos we can provide this facility also.

Suppose we are having a data as,

This data can be easily shown in pivot table in the same format, but user want to create new expression to compare and calculate percentage of consecutive years

		2010	2010	2011	2011	2012	2012	2013	2013	2014	2014
Category 1	Category 2	Orders Entered	Invoice Amount	Orders Entered	Invoice Amount	Orders Entered	Invoice Amount	Orders Entered	Invoice Amount	Orders Entered	Invoice Amount
PANELBOARDS (0075)	Main Plant	89725662.51	92793731.96	91599116.26	105195095.5	5097235.68	117038675	6182317.15	112664308.9	3501778.58	69060955.75
PANELBOARDS (0075)	Satellite Plant	59845608.5	60362563.25	50174799.88	65838125.77	0	70422171.34	0	70953074.46	0	41200077.76
PANELBOARDS (0075)	Service Center	0	0	291502.87	0	3787544.1	0	6261360.25	0	3367268.38	0
PANELBOARDS (0075)	Unknown PlantLocationTy	-5855.97	0	8122.73	0	0	0	0	0	0	0
POW R LINE C SWBD (0105)	Main Plant	64928019.4	60033924.39	74039146.18	82375085.05	4054397.43	90677791.6	7861969.58	91118522.17	2085983.96	56183671.52
POW R LINE C SWBD (0105)	Satellite Plant	101112005.8	98400261.96	84445924	105941846.7	40538.69	119755511.3	22040.31	121493446.5	10851.11	71814336.25
POW R LINE C SWBD (0105)	Service Center	0	0	319274.02	0	710839.39	0	1051305.08	0	695058.59	700
POW R LINE C SWBD (0105)	Unknown PlantLocationTy	-20	0	4580.41	0	0	0	0	0	0	0
SAFETY SWITCHES (S045)	Main Plant	90704852.26	86028208	81174798.67	98219182.6	23669815.76	108100555.8	23752565.3	110314282.5	10578771.12	69152154.4
SAFETY SWITCHES (S045)	Satellite Plant	0	0	81.84	0	97.4	0	0	0	0	0
SAFETY SWITCHES (S045)	Service Center	0	0	0	0	0	0	4929	0	0	0
SAFETY SWITCHES (S045)	Unknown PlantLocationTy	-307790.33	0	-189832.51	0	0	0	0	0	0	0