topic Re: How to write expression in drilldown? in QlikView

How to write expression in drilldown?

Mon, 27 Oct 2014 05:42:10 GMT

hi,

I created drill down in qlikview like this country, city, population, but the drilldown not work .the problem is when i click the drilldown arrow symbol the value did not change .after I use expression like this [Getcurrentfield Country_city=(Country>city>Population)]but the expression not work because It show Error .I do not know how to overcome this problem please tell me out how to solve this problem.

I attached snipping file below this box.

Points:

1.Groupname -[Country_city]

2.Group values - Country,City,Population

Regards:

Madhu.

Re: How to write expression in drilldown?

ashfaq_haseeb — Mon, 27 Oct 2014 05:44:50 GMT

Hi,

Can you explain, what are you trying to achieve here?

If possible post sample data with expected output.

Regards

ASHFAQ

Re: How to write expression in drilldown?

Anonymous — Mon, 27 Oct 2014 05:47:57 GMT

What is your exact expression...

The condition you have given is wrong for expression...

If sample qvw can be provided, we can resove the issue in more efficient way...

Re: How to write expression in drilldown?

tresB — Mon, 27 Oct 2014 05:49:52 GMT

Ideally, you don't need write expression with GetCurrentfield(), it should work with simple expression like: =Sum(ValueField)

Re: How to write expression in drilldown?

Mon, 27 Oct 2014 06:02:37 GMT

Thanks Asfaq Mohammed

I have data like this Country field have Countrynames,City field have City names and population field have population.

actually I want like this If I click Arrow button the values change.

for example:If The chart show country names that time We click on the Arrow button the Chart show city names. automatically.How to do this tell me Ple

Regards

Madhu

Re: How to write expression in drilldown?

Anonymous — Mon, 27 Oct 2014 06:04:28 GMT

Simply provide your group in dimension and in expression give, sum(sales) for example

It will work as required....

Re: How to write expression in drilldown?

ashfaq_haseeb — Mon, 27 Oct 2014 06:06:56 GMT

HI,

This is not how Qlik Works. You need to select any particular country and then it will list cities under that country and so on.

Hope it helps.

If it answer, please mark this thread as correct or helpful.

Regards

ASHFAQ

Re: How to write expression in drilldown?

Mon, 27 Oct 2014 06:07:12 GMT

Hi Madhu,

You can display in a text-box which field in a drill-down or cyclic group is active using:

In your case it would be:

=GetCurrentField("Country_city")

I am also attaching a sample qvw with drilldown group for reference.

Re: How to write expression in drilldown?

jagan — Mon, 27 Oct 2014 06:36:31 GMT

Hi,

Create Cyclic Group with Country, City

Now in chart:

Dimension: Cyclic Group Name

Expression: Sum(Population)

No need of GetCurrentField(), if you click on the group the dimension changes, based on the dimension the values are calculated.

Hope this helps you.

Regards,

Jagan.

Re: How to write expression in drilldown?

Mon, 27 Oct 2014 06:37:04 GMT

Hi,

Here you have Country,City,Population values in drill down group.dnt click on Arrow symbol.just click one any one country then city then population then if you want drill up just click on arrow symbol.qlikview has unique drilldown feature

Re: How to write expression in drilldown?

Mon, 27 Oct 2014 07:15:52 GMT

Nitin this is my expression but it show error

=GetCurrentField(Country_city=(Country>City>Population))

Regards:

madhu

Re: How to write expression in drilldown?

jagan — Mon, 27 Oct 2014 07:21:30 GMT

Hi Madhu,

Can you attach the sample file? or can you explain with some sample data.

Regards,

Jagan.

Re: How to write expression in drilldown?

Anonymous — Mon, 27 Oct 2014 09:35:25 GMT

Yes it will give error, as its not the correct way to define expression.

Please post a sample qvw , I will provide you the solution