Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have attached data file on which I need to make a bar chart and date i need to divide in three parts i.e
If someone Select 2014 as year on dashboard then
M0 - show Dec 2014 data
M1 - Nov 2014 data
M2 - rest of the months data
M0, M1 and M2 are x-axis label and sum of stock we need to output on Y axis.
Extend your data on load to create your reporting baskets.
Add Year column based on the stock date
Add M column based on
M0= stock date in December
M1= stock date in November
M2= stock date not in November or December
Then you should be able to create your chart you want quiet easily.
Regards
Andy
@Andy Weir Please send me a example how it is possible i m new in qliksense
Hi
attached qvf file with requested requirments :
Add year as dimension base on stock Date
Add a dimension Mperiod with M0 M1 and M2 regarding the period month décember november other
Hope it helps,
Bruno
script :
[Sheet1]:
LOAD [StockDate],
year(StockDate)as "YearStock",
if(month(StockDate)=12,'M0 dec',if(month(StockDate)=11,'M1 nov','M2 other')) AS "Mperiod",
[TotalStockVal]
FROM [lib://test 1/Copie de data.xlsx]
(ooxml, embedded labels, table is Sheet1);
Sir this is not work full for us because our date is dynamic and it working on max date variable we cant give a static date in this
Hi
I'm not sure to understand what you want exactely as you first talk about selecting year.
Did you mean you want only the last year with data in november and december ?
Bruno
Hi Mohit
Bruno has delivered what you asked for using the method I suggested.
What do you mean by date is dynamic? I think perhaps a mock up of your proposed solution would help clarify things.
Regards
Andy