topic Make columns appear at drilldown level in QlikView

Make columns appear at drilldown level

Tue, 18 May 2010 03:18:34 GMT

Hi all,

is it possible to have columns appear only at drilldown level? My situation is some columns are irrelevant at the first level of drilldown, it is only relevant when i get to the lower level. Thanks.

Make columns appear at drilldown level

deepakk — Tue, 18 May 2010 06:22:23 GMT

If you have using a straight table then it is possible to do so.You can hide the column based on Condition. Go to presenation you will find the option of hiding the column.

Make columns appear at drilldown level

Tue, 18 May 2010 07:30:02 GMT

thanks for that, i found the "hide column", but where do i enter the condition? What should the syntax be to indicate which level of drill down the column should apear?

Make columns appear at drilldown level

Tue, 18 May 2010 07:37:41 GMT

Hi Danny,

You can also control by macro.

upon select of a particular data in a field you can enable or disable the expression.

The below macro help to disable a expression

set chart = ActiveDocument.ActiveSheet.CreateStraightTable
chart.AddDimension "Customer"
chart.AddDimension "ProductType"
chart.AddExpression "sum(Amount)"
chart.AddExpression "count(Customer)"
set cp = chart.GetProperties
set expr = cp.Expressions.Item(0).Item(0).Data.ExpressionData
expr.Enable = false 'disable first expression
chart.SetProperties cp

Regards

Rajesh

Make columns appear at drilldown level

Tue, 18 May 2010 08:05:58 GMT

Hi,

Check the attached application.

Here i have pivot table , which shows sum of value when nothing is selected or with out drilldown. if you drill down to next level it will show count of value.

Expression has to be written in presentation tab of straight table and select the expression and choose conditional show option and write your expression.

Hope this will help you.

-Peterson

Make columns appear at drilldown level

Mon, 31 May 2010 01:19:23 GMT

You seem to have done that in QV 9, I cant see what you are saying, i cant write expressions in the presentation tab

Re: Make columns appear at drilldown level

Fri, 09 Aug 2013 19:37:30 GMT

Works perfect for me thank you