topic Re: question about bar offset in QlikView

question about bar offset

Anonymous — Mon, 15 Aug 2016 14:45:53 GMT

Hi all,

I need to create a bar chart which shows the gender/age structure of the readers of editions.

I need to set a bar offset between men and women.

But it fails to work as required.

Could you look at the file attached and give me a prompt?

Thank you in advance,

Larisa

sunny_talwar — Mon, 15 Aug 2016 14:53:34 GMT

How about this:

=If(WildMatch(Only(Group), 'women*') and WildMatch(Above(Only(Group)), 'women*') = 0, 3)

Anonymous — Mon, 15 Aug 2016 15:15:36 GMT

Thanks, Sunny!

The solution is simple and nice. I appreciate.