Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
mohitd910
Creator II
Creator II

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

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.

6 Replies
ogster1974
Partner - Master II
Partner - Master II

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

mohitd910
Creator II
Creator II
Author

@Andy Weir  Please send me a example how it is possible i m new in qliksense

brunobertels
Master
Master

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);

mohitd910
Creator II
Creator II
Author

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

brunobertels
Master
Master

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

ogster1974
Partner - Master II
Partner - Master II

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