Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

How to write expression in drilldown?

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.

Sddown.JPG.jpg

12 Replies

Re: How to write expression in drilldown?

Hi,

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

If possible post sample data with expected output.

Regards

ASHFAQ

gupta_n8
Valued Contributor II

Re: How to write expression in drilldown?

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...

MVP
MVP

Re: How to write expression in drilldown?

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

Not applicable

Re: How to write expression in drilldown?

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

gupta_n8
Valued Contributor II

Re: How to write expression in drilldown?

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?

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

Not applicable

Re: How to write expression in drilldown?

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.

MVP
MVP

Re: How to write expression in drilldown?

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.

Not applicable

Re: How to write expression in drilldown?

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

Community Browser