topic Re: How to set expression in Drilldown? in QlikView

How to set expression in Drilldown?

Sun, 23 Nov 2014 11:51:39 GMT

Hi,

I created drilldown in my qvw.I wrote expression like this GetCurrentField(NewGroup)='ID','Monthname','Date') but It expression show error in my edit expression box.I do not know how to solve error in expression.Pleasse tell me out how to write condition in driil down chart in qlikvieew.

thank you

Regards:

Madhu

Re: How to set expression in Drilldown?

MarcoWedel — Sun, 23 Nov 2014 12:13:14 GMT

Can you describe what this condition is supposed to do?

regards

Marco

Re: How to set expression in Drilldown?

ecolomer — Sun, 23 Nov 2014 12:29:25 GMT

Can you explain more your situation and requeriments?

Re: How to set expression in Drilldown?

veidlburkhard — Sun, 23 Nov 2014 13:37:09 GMT

Hi Madhu,

you will always get an error in the edit expression box, when using GetCurrentField(...). This is a mistake of QV. You can ignore that. No problem.

Regards

Burkhard

Re: How to set expression in Drilldown?

jagan — Sun, 23 Nov 2014 13:50:27 GMT

Hi,

If(GetCurrentField(NewGroup)='ID','Monthname','Date'))

You need to use If statement like above, can you explain bit more what you are trying to do.

Regards,

Jagan.

Re: Re: How to set expression in Drilldown?

Anonymous — Sun, 23 Nov 2014 14:20:56 GMT

I am not sure what you after either, But it made me think about doing something like this :

=if ( GetFieldSelections ( Dim1) = 'A' , 'Dim2' , 'Dim3' )

So that the lower drill dimension depends on what DimA you select.

Re: How to set expression in Drilldown?

Tue, 25 Nov 2014 03:57:15 GMT

Hi Marco,

actually I Take dimiensions i.eProduct,Quantity,Price) after I grouped all this dimensions then after I wrote Expression

like this GetCurrentField(NewGroup_Pro)='Product','Qty','Price') for Drill down but it is not work .Itcondition show error in expression box.tell me out how to solve this problem.

thank you

Regards:

Madhu

Re: How to set expression in Drilldown?

Tue, 25 Nov 2014 03:59:24 GMT

Hi Enrique,

actually I Take dimiensions i.eProduct,Quantity,Price) after I grouped all this dimensions then after I wrote Expression

like this GetCurrentField(NewGroup_Pro)='Product','Qty','Price') for Drill down but it is not work .Itcondition show error in expression box.tell me out how to solve this problem.

thank you

Regards:

Madhu

Re: How to set expression in Drilldown?

Tue, 25 Nov 2014 04:01:40 GMT

Hi Bill,

actually I Take dimiensions i.eProduct,Quantity,Price) after I grouped all this dimensions then after I wrote Expression

like this GetCurrentField(NewGroup_Pro)='Product','Qty','Price') for Drill down but it is not work .Itcondition show error in expression box.tell me out how to solve this problem.

thank you

Regards:

Madhu

Re: How to set expression in Drilldown?

sasikanth — Tue, 25 Nov 2014 04:26:57 GMT

how can you take Quantity and Price as Dimensions

Let us know what exactly your requirement ,

what is there in Newgroup_Pro ..

Thanks

Sasi

Re: How to set expression in Drilldown?

jyothish8807 — Tue, 25 Nov 2014 04:44:16 GMT

Hi madhu,

In dimension take;

1. Your drill down

2. MonthName

3.Date

Now in show condition column of Monthname and Date wrtie the following:

getcurrentfield(Newfield)='ID'

I guess you are trying to disable and enable a field Date and MonthName according to your condition.

Regards

Re: How to set expression in Drilldown?

jagan — Tue, 25 Nov 2014 05:24:36 GMT

Hi,

Tried this expression without quotes

If(GetCurrentField(NewGroup)='ID', Monthname, Date))

Regards,

Jagan.