topic Re: Bar Chart expression (not calculated) in QlikView

Bar Chart expression (not calculated)

Thu, 06 Feb 2014 20:12:14 GMT

Hi,

I have a set of calculated data which I would like to show them on chart. Column A contains Business functions and column B contains all weekly sales, Column C contains Regions. I want to write a chart expression that selects column A = 'Consumer' and displays all weekly sales from column B. The Dimension will be Regions.

Thanks in advance.

Jasmine

Re: Bar Chart expression (not calculated)

brindlogcool — Thu, 06 Feb 2014 20:43:44 GMT

If i understand the requirement correctly you can use column A ,Column C in the dimension and the sales in the expression.

Re: Bar Chart expression (not calculated)

iktrayanov — Thu, 06 Feb 2014 20:59:34 GMT

In your chart use

Dimension >>> Regions

Expression >>>> Sum({<A = {Consumer}>}sales)

Re: Bar Chart expression (not calculated)

Thu, 06 Feb 2014 21:00:27 GMT

Hi,

Thank you for your response. I want to see if I'm able to make the selection (Column A = 'Consumer') in the expression.

Jasmine

Re: Bar Chart expression (not calculated)

Thu, 06 Feb 2014 21:02:29 GMT

I don't want to get Sum of the Sales because I want to display as it is.

Thanks,

Jasmine

Re: Bar Chart expression (not calculated)

iktrayanov — Thu, 06 Feb 2014 21:03:58 GMT

It will display sales per Region

Re: Bar Chart expression (not calculated)

iktrayanov — Thu, 06 Feb 2014 21:06:41 GMT

If you want to show details don't use chart just use table box.

Re: Bar Chart expression (not calculated)

brindlogcool — Thu, 06 Feb 2014 21:10:11 GMT

As Ivan suggested you can display the data in table. Or you have pass the selection in expression.

Re: Bar Chart expression (not calculated)

Thu, 06 Feb 2014 21:13:55 GMT

Thank you so much for quick responses.

Jasmine