How to create Adhoc Reports

[#1]

Hi

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

[sujeetsingh]

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

[#3]

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

[veeranj]

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

[sujeetsingh]

See the sample

[jagan]

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.

[#7]

@ Jagan Mohan : Thanks .. It was helpful

[#8]

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?

[#9]

@ 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?

[#10]

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?