Qlik Community

QlikView Documents

Documents for QlikView related information.

Adhoc reporting in Qlikview

MVP & Luminary
MVP & Luminary

Adhoc reporting in Qlikview

Hi,

Please find the attached file helps you in implementing the Adhoc reports in Qlikview with the help of Qlikview 11 new feature "Show/Hide dimensions and expressions based on condition" in Dimension Tab - Enable Conditional and Expression Tab - Conditional option.

To implement this I created 2 new tables called Dimension and Measures tables which has list of Dimensions and Measures used for creating Adhoc Report.

Refer below link for detailed explanation:

Customizable Straight Table

Regards,

Jagan.

Attachments
Comments
msvanfeldt
New Contributor II

Hi,

An even better solution is to use the formula:

=SubStringCount('|' & Concat(distinct Dimension, '|') & '|', '|Customer Name|')

To prevent dimensions and/or expressions with similar names, ie "Customer" and "Customer Name", to be shown.

/Magnus

MVP & Luminary
MVP & Luminary

Hi Magnus,

You are correct, I will update and attach.

Regards,

Jagan.

0 Likes
Not applicable

Can someone please look into my example, i am doing this bit differently then shown but i am not getting desired results.

In my case everything shows up regardless off selection.

0 Likes
Not applicable

Data:

LOAD * INLINE [   

    Id, Year, Company, Sales

    1, 2013, A, 100

    5, 2013, A, 200

    2, 2013, B, 200

    3, 2012, A, 300

    6, 2012, A, 250

    4, 2012, C, 150

];

Dimensions:

LOAD

*

INLINE [

Dimension, Dimension_flag

Id, 1

Year, 2

Company, 3 ];

Measures:

LOAD

*

INLINE [

Measure, Measure_flag

Count, A

Sum, B

Average, C ];

my formula for Dimension

=SubStringCount(concat(Dimension_flag, '|', 3)

=SubStringCount(concat(Measure_flag, '|', A)

msvanfeldt
New Contributor II

It's just a syntax error, try writing the formulas like this:

=SubStringCount(concat(Dimension_flag, '|'), 3)

=SubStringCount(concat(Measure_flag, '|'), 'A')

Not applicable

Hi for all Another option for solve the issue is

=SubStringCount(Concat(Hash256(Dimension_flag), '|'), Hash256(3))

=SubStringCount(Concat(Hash256(Measure_flag), '|'), Hash256('A'))

This option make unique the comparision for expressions or dimentions to select. I tested in many models and works fine.

Example:

Expressions to select:

Revenue

Revenue (%)

Cost

Cost (%)

Expenses

Expenses (%)

EBIT

EBITD

EBITDA

ROI

ROE

EBITDA Margin

Margin

Net Margin

0 Likes
rsdhavle
Contributor II

Thanks for post..lets say i want to introduce one more dimension as dimension 2 and keep it optional..so if user wants to check some data based on two dimension stacked bar charts etc..how can we do it? I am struggling to get 2nd dimension into picture at the moment

0 Likes
MVP & Luminary
MVP & Luminary

Hi Rohan,

Load the same dimension table again with different field name and follow the same process which we did for first dimension.

Regards,

Jagan.

0 Likes
rsdhavle
Contributor II

can we control which dimension i want in stack and which i want on an x axis?..At the moment what happening is whichever dimension has more values it automatically goes on x axis and the one with less values gets stacked

0 Likes
MVP & Luminary
MVP & Luminary

Hi,

I think this depends on the order of the Dimension in the Dimensions tab, try changing the Dimensions order.

Regards,

Jagan.

0 Likes
Version history
Revision #:
1 of 1
Last update:
‎11-21-2013 09:48 PM
Updated by: