nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

INSERTING conditional filter on datCube

Shakill

Hello everyone,
I am actually using BIRT 3.7.0 and i am having a problem making a conditional filter on a datacube using expression builder:
I have uploaded a print screen attachment(expressionBulider001.png).
You can see from tha attachement that i am doing a filter on the field dataSetRow["MOIS"] . I also have an another field using dataSetRow["ANNEE"].what i want to do using the expression builder is :
if( dataSetRow["ANNEE"]== 2013){ //filter the datacube using dataSetRow["MOIS"] = feb, march.april }
else if( dataSetRow["ANNEE"]== 2014){ //filter the datacube using dataSetRow["MOIS"] = May, June,July} Depending on the value of dataSetRow["ANNEE"], i want to filter the datacube using the field dataSetRow["MOIS"] by the above mentioned values.
if anyone can post a simple example on the above issue or printscreen(even better) , i will be very grateful.
Thanks in advance

Find more posts tagged with

Comments

Stephan Lau

Hi Shakill, maybe you can use the "Is True" filter condition to achieve the wanted filter result!?Just put all the filter logic in the right site of the filter condition. Something like:<pre class="_prettyXprint _lang-js">var filterResult = false;if (dataSetRow["ANNEE"]== 2013) { if (dataSetRow["MOIS"] == "feb" || dataSetRow["MOIS"] == "march" || dataSetRow["MOIS"] == "april") { filterResult = true; }} else if (dataSetRow["ANNEE"]== 2014){ if (dataSetRow["MOIS"] == "May" || dataSetRow["MOIS"] == "June" || dataSetRow["MOIS"] == "July") { filterResult = true; }}filterResult;</pre> Hope this helps!