topic Re: How to create Adhoc Reports in QlikView

How to create Adhoc Reports

Wed, 20 Nov 2013 05:49:41 GMT

I have a scenario where Dynamic Reports has be created. Inputs Needed

Example

Dimensions:

Country

City

Branch

Measures:

YTD

YTDN-1

No of Customers

Thanks

Senthil Kumar P

Re: How to create Adhoc Reports

sujeetsingh — Wed, 20 Nov 2013 05:53:35 GMT

Please explain that what of the data fields are to be entered at UI level by user.

The Dimensions are fixed or they too are dynamic

Re: How to create Adhoc Reports

Wed, 20 Nov 2013 05:56:58 GMT

The Dimensions and Measures are Fixed. The Users may select on the respective Dimension and Measures. Based on that the report should be generated in Table Format

Re: How to create Adhoc Reports

veeranj — Wed, 20 Nov 2013 06:32:50 GMT

Hi Senthil,

Refer to the Reports tab in the "Whats New in QlikView11" qvw file which will be available in the path

C:\Program Files\QlikView\Examples\Documents on ur system.

Regards,

Anjee

Re: How to create Adhoc Reports

sujeetsingh — Wed, 20 Nov 2013 06:36:18 GMT

See the sample

Re: How to create Adhoc Reports

jagan — Wed, 20 Nov 2013 06:58:25 GMT

Hi Senthil,

Please find attached file hope it helps you. It is implemented by using Enable Condtional in Dimension tab and Conditional in Expression options.

Regards,

Jagan.

Re: How to create Adhoc Reports

Wed, 20 Nov 2013 07:05:38 GMT

@ Jagan Mohan : Thanks .. It was helpful

Re: How to create Adhoc Reports

Wed, 20 Nov 2013 07:50:30 GMT

Hi Jagan..

Thanks. I have a doubt . If i select 2 Dimension and 1 Measure , The table should show only the selected Values. But it is displaying for all Dimensions and Measures. Do you have any idea on that?

Re: How to create Adhoc Reports

Wed, 20 Nov 2013 07:57:18 GMT

@ Jagan Mohan

Thanks. I have a doubt . If i select 2 Dimension and 1 Measure , The table should show only the selected Values. But it is displaying for all Dimensions and Measures. Do you have any idea on that?

Re: How to create Adhoc Reports

Wed, 20 Nov 2013 08:00:35 GMT

Hi Jagan..

Thanks..

If i select Company , ID in Dimension and Average in Measure , The table should show only

Company , ID, Average. Do you have any idea on how to implement this?

Re: Re: How to create Adhoc Reports

Wed, 20 Nov 2013 08:24:54 GMT

Hi Senthil,

PFA.

I have modified the file sent by Jagan. You can make the columns conditional so that they will be shown only when intended.

Hope it helps!

Re: How to create Adhoc Reports

Wed, 20 Nov 2013 08:40:11 GMT

Hi Senthil,

1) You need to create a data island: it means you will populate a table related to no other table of your model. let's create a Dimension table:

LOAD * INLINE [

Dimension

MyDim1

MyDim2

MyDim3
];

Do the same with the measure

2) You create a ListBox with that dimension, a LB with the measures

3) In the table:

a) create calculated dimensions

for the 1st one: = $(=SubField(concat(distinct Dimension, '|'), '|', 1))

b) Click Enable Conditional for this dimension: =(GetSelectedCount(Dimension) >=1)

The measure will be quite the same: sum($(=Measname)) or if you have entered directly the equation into the load script : $(=Meas_Equation)

This technique does not work too much with Set Analysis but it should wrk for you.

Fabrice

Re: Re: How to create Adhoc Reports

Wed, 20 Nov 2013 08:41:29 GMT

@ Shyamal Pandit

Thanks. But if i select the Dimension and Measures , Dimension is not visible in the Table and It is Not working if i select 2 Measures also.

Re: Re: How to create Adhoc Reports

Wed, 20 Nov 2013 08:48:13 GMT

If you want to use several measures, use the same syntax as for Dimension.

Enable the nth measure if you have chose more than N measures, the expression is quite the same as for the dimension.

Fabrice

Re: Re: Re: How to create Adhoc Reports

jagan — Wed, 20 Nov 2013 10:37:40 GMT

Hi,

Please find updated file attached.

Regards,

Jagan.

Re: How to create Adhoc Reports

Wed, 20 Nov 2013 11:19:58 GMT

Please find a QVW file and a XLS file used to create this QVW: the whole in Customer.zip

the QVW comes from a personal version but you should be able to open it.

Good luck

Fabrice