QlikView documentation and resources.
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:
Regards,
Jagan.
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
Hi Magnus,
You are correct, I will update and attach.
Regards,
Jagan.
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.
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)
It's just a syntax error, try writing the formulas like this:
=SubStringCount(concat(Dimension_flag, '|'), 3)
=SubStringCount(concat(Measure_flag, '|'), 'A')
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
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
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.
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
Hi,
I think this depends on the order of the Dimension in the Dimensions tab, try changing the Dimensions order.
Regards,
Jagan.