topic Pls Help! Calculating Expression as Dimension in QlikView

Pls Help! Calculating Expression as Dimension

delmak2000 — Thu, 05 Sep 2013 07:30:45 GMT

Hi all,

I really need help as regards using an expression as a dimension. I have tried using the added calculated dimension with no success.

For example;

The Table Chart below, shows Total no of SKU, we have generated values for Column "days to clear stock".

We want to count the no of values that are less than a particular range or number And have it has displayed in the diagram below. Or if the Keys # months to clear inventory could be displayed on the x axis of the bar chart.

Thanks

Ayodele



233 SKUS	#464	# months to clear inventory
50%	50%	<.5
15%	15%	.5-1
10%	10%	1-3
25%	25%	3-6
		6-12
		>12

Message was edited by: Ayodele Makun

Re: Pls Help! Calculating Expression as Dimension

Vegar — Thu, 05 Sep 2013 07:41:42 GMT

I don't get your problem, sorry.

Could you provide a qwv with data or/and picture of tables with your data and a mock-up table of what you want to achieve?

Re: Pls Help! Calculating Expression as Dimension

delmak2000 — Thu, 05 Sep 2013 08:20:15 GMT

Hi Vegar,

I would attach a qvw document but it might be heavy but rather you look at the excel document which i attached.

I would try explaining what data are available.

We have the number of stock and the different dates in which it was sold.

What we have done is to generate results for how many items has been sold and the duration in days for when it was sold.

So we intend to generate a chart showing what amount or quantity has been sold in a time frame

Re: Pls Help! Calculating Expression as Dimension

delmak2000 — Thu, 05 Sep 2013 10:32:26 GMT

its something like this, but you note the class range in the third column was generated based on master.day range and it picks the first value based on the first day of transaction of 5, but really its a value of one (1) i desire.

thanks