topic Re: Some static bars in chart? in QlikView

Some static bars in chart?

magnuslander — Mon, 22 Jun 2015 14:59:47 GMT

Is it possible to have some of the bars remain constant when drilling down in the others? Is set analysis the way to do it?

The chart displays sales by customer group (10 highest). If we drill down, the chart shows sales per customer. But I'd like the red inked bars in the image to continue displaying customer group and not customer. The ones on the left should change as usual.

I have unique codes per customer group and customer.

I tried with: sum( {$<[CustomerGroup]={'CG1', 'CG2', 'CG3'} [SalesAmount] ) and it displays the red inked bars fine but the others are displayed incorrect.

Re: Some static bars in chart?

Anonymous — Mon, 22 Jun 2015 15:04:47 GMT

Why not use 2 seperate charts, one for the fixed bars and the other for the bars that change.

Re: Some static bars in chart?

hic — Mon, 22 Jun 2015 15:24:56 GMT

Try

Sum( {$+1<[CustomerGroup]={'CG1', 'CG2', 'CG3'} [SalesAmount] )

HIC

Re: Some static bars in chart?

magnuslander — Tue, 23 Jun 2015 07:36:33 GMT

Thanks! Almost! The problem with $+1 is that CG1 is dropped from the view. CG2 and CG3 display fine. I guess because it's not one of the 10 highest?