topic Drill down issue for distinct values in QlikView

Drill down issue for distinct values

siddharth_kulka — Mon, 02 Aug 2010 16:37:53 GMT

Hi,

Please consider the below example:

Type Area Region Calls

National 1 1 50

National 1 2 100

National 2 1 150

If I have a drill down group with Type, Area, Region and use the same in a straight table, the drill down starts with Area instead of Type. But the requirement is to have Type first. Is this an issue with Drill Down Charts in 9.0 SR3(for a distinct value for the first dimension(National in this case)).

I donot see this issue in 8.5. Please confirm this as a bug in 9.0 SR3!

Thanks,

Siddharth

Drill down issue for distinct values

siddharth_kulka — Thu, 05 Aug 2010 14:52:15 GMT

Any feedback will be appeciated!

Drill down issue for distinct values

dirk_konings — Thu, 05 Aug 2010 14:57:15 GMT

This is normal behaviour for a drill down dimension. If there is only one value available, it jumps to a lower level.

Drill down issue for distinct values

siddharth_kulka — Thu, 05 Aug 2010 15:14:23 GMT

Well, in 8.5

If there is only one value available, it DOESNOT jump down to a lower level. I was using 8.5 for a while and hence could not the difference.

Thanks,

Siddharth

Drill down issue for distinct values

siddharth_kulka — Thu, 05 Aug 2010 15:18:20 GMT

Well, in 8.5 If there is only one value available, it DOESNOT jump down to a lower level. I was using 8.5 for a while and hence could note the difference. So this is unusual!

Drill down issue for distinct values

dirk_konings — Thu, 05 Aug 2010 15:53:41 GMT

still the issue in SR5 to. Workaround by adding a NULL value to the list of values you don't want to skip.

Drill down issue for distinct values

siddharth_kulka — Thu, 05 Aug 2010 16:46:07 GMT

Works! Thanks!