Qlik Community

QlikView Documents

Documents for QlikView related information.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.

Adhoc reporting in Qlikview

MVP
MVP

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
MVP

Hi Magnus,

You are correct, I will update and attach.

Regards,

Jagan.

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.

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

rsdhavle
Contributor

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

MVP
MVP

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.

rsdhavle
Contributor

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

MVP
MVP

Hi,

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

Regards,

Jagan.

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