Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
CAN we create a chart creation wizard functionality via Adhoc query....
I do not think this can be done.
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
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.
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
Yes.. Ad Hoc Reporting is possible.
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 |