topic chart dimension in QlikView

chart dimension

Mon, 10 Nov 2014 09:19:12 GMT

hi dears

i have a line chart that shows [Sales] for each [Day], means a chart with sales as X axes and Day for y axes.

now, i want to let user to see [Sales] for each ''n'' day they choose dynamically. i mean i want to let them to see sales for each three days or for each seven day or ...(as they choose at the moment)

how can i doo that?

regards,

mana

Re: chart dimension

Anonymous — Mon, 10 Nov 2014 09:48:40 GMT

STEP1: Create a variable for Days

STEP2: Create Text box with the created variable

STEP3: Link the chart with Variable(which you created using Dimention Limit)

Re: chart dimension

its_anandrjs — Mon, 10 Nov 2014 09:52:23 GMT

Hi,

You can use Class function for this and use variable to input the days value for the days interval to show on the chart please see help from the QV help

Create variable x and and used it in place of the day dimension.

Creates a classification of expressions. The bin width is determined by the number set as interval. The result is shown as a<=x<b, where a and b are the upper and lower limits of the bin. The x can be replaced by an arbitrary string stated in label. 0 is normally the default starting point of the classification. This can be changed by adding an offset.

Examples:

class( var,10 ) with var = 23 returns '20<=x<30'

class( var,5,'value' ) with var = 23 returns '20<= value <25'

class( var,10,'x',5 ) with var = 23 returns '15<=x<25'

Regards

Anand