Qlik Community

Qlik DataMarket Discussions

Discussion Board for collaboration regarding Qlik DataMarket.

jeevays7
Contributor II

how one expression will work based on one dimension and another expression work based on both of two dimension

Hi all,

I have t data like this,

 

NameDatePNL
A1-Sep-1610
A2-Sep-165
A3-Sep-162
A4-Sep-163
B1-Sep-1620
B2-Sep-165
B3-Sep-163
B4-Sep-162
C1-Sep-1610
C2-Sep-1610
C3-Sep-162
C4-Sep-165
D1-Sep-1610
D2-Sep-165
D3-Sep-165
D4-Sep-1610

from above data i need the result like below. in YTD field sum of PNL from year start to month end (i.e4-Sep-16). here month is September. and month end is 4-Sep-16. if i select a date, the result will come in MTD as well as YTD, and the dates (i.e 1-Sep-16 to 30-Sep-16) will come month start to month end of selected date.

Result:

NameMTDYTD1-Sep-162-Sep-163-Sep-164-Sep-16
A2010010523
B3020020532
C27300101025
D30250105510

I have Name and Date as dimension. i need Name wise MTD and YTD and date wise. but date is presented in like column name as above.

Community Browser