Drill-Downs

[#1]

I am trying to create a bar chart that drills down from the state to the city. The row with the blank city is more or less a total row that averages the percentages. I would like the Pennsylvania to show with a percentage of 20% as the first layer, and then once the user clicks on Pennsylvania, Pittsburgh and Philadelphia show with their percentages. Right now, Pennsyvania is showing with a blank percentage, but will drill down to Philadelphia and Pittsburgh. How can I get Qlik View to pull 20% for Pennsylvania instead of showing a blank? Thanks in advance for the help!

State	City	Percentage
Pennsylvania		20%
Pennsylvania	Philadelphia	10%
Pennsylvania	Pittsburgh	30%

[#2]

Hi,

Are you getting your data from the source in the way you have mentioned here?

If possible can you share qvw with dummy data?

Regards,

Jemimah

[jagan]

Hi,

Try like this in script

LOAD

*,

If(Len(Trim(City)) = 0, State, City) AS City_New

FROM DataSource;

Now use State and City_New in your drilldown dimension.

Note: you cannot drilldown with in the same dimension, drilldown can be done in different dimensions.

Hope this helps you.

Regards,

Jagan.

[jonathandienst]

If you want help debugging an expression, it would be useful to know what the expression is. In general, the more you provide with your post, including sample files, the more relevant and useful will be the responses.