topic Problem on drill down in QlikView

Problem on drill down

Wed, 25 Aug 2010 10:29:37 GMT

Hi Guys,

I have a bar chart that shows total count and Duraion of CDRs by date,switch,element id(group by fields).

Now i have a problem with the drill down. First drill down(value by date) is working after that its not showing the value by switch or element id.

See the attached file.In this file i have data for Apr12 th by different switch. But it is not drilling down to the next level

Thanks in advance for any suggestions.

Praveena

Wed, 25 Aug 2010 20:46:59 GMT

Hi,

if i check the table structure - there no links between the tables!

In the dimension you are using "month_day_retail" of Table "TS_RECON_1_SWT_MED_RET"

and in the formula fields of Table "ts_recon_3_swt_med_intl".

Try to link the tables so Qlikview has a chance to find values.

Best regards

Michael

Thu, 26 Aug 2010 08:30:26 GMT

Hi Michael,

Thanks for your reply..

If u see the dimension tab,the used dimesion is "DD-International" not retail