Qlik Community

Qlik Sense Deployment & Management

Discussion board where members learn more about Qlik Sense Installation, Deployment and Management.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Highlighted
mohitd910
Contributor 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
Honored Contributor II

Re: 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-

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
Contributor II

Re: 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-

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

brunobertels
Valued Contributor II

Re: 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-

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
Contributor II

Re: 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-

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
Valued Contributor II

Re: 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-

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
Honored Contributor II

Re: 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-

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