topic Re: Drill-Downs in QlikView

Drill-Downs

Thu, 04 Jun 2015 02:21:54 GMT

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%

Re: Drill-Downs

Thu, 04 Jun 2015 04:15:27 GMT

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

Re: Drill-Downs

jagan — Thu, 04 Jun 2015 05:03:55 GMT

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.

Re: Drill-Downs

jonathandienst — Thu, 04 Jun 2015 05:05:50 GMT

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.