topic Creating a variable in QlikView https://community.qlik.com/t5/QlikView/Creating-a-variable/m-p/812001#M286609 <HTML><HEAD></HEAD><BODY><P>Hi There</P><P></P><P>I am trying to create a variable for max date but it should look at max date regardless of the selection</P><P></P><P>vMAXPERIOD=Max(Fiscal Month)</P><P></P><P>I have a fiscal month selector on my dashboard but in a certain expression I want to use an if statement saying if the fiscal month = vMAXPERIOD , expression , 0</P><P></P><P>problem is with the Max(Fiscal Month) it looks at the max of the selected fiscal month</P><P></P><P>Thanks </P></BODY></HTML> Thu, 11 Dec 2014 08:11:22 GMT rido1421 2014-12-11T08:11:22Z Creating a variable https://community.qlik.com/t5/QlikView/Creating-a-variable/m-p/812001#M286609 <HTML><HEAD></HEAD><BODY><P>Hi There</P><P></P><P>I am trying to create a variable for max date but it should look at max date regardless of the selection</P><P></P><P>vMAXPERIOD=Max(Fiscal Month)</P><P></P><P>I have a fiscal month selector on my dashboard but in a certain expression I want to use an if statement saying if the fiscal month = vMAXPERIOD , expression , 0</P><P></P><P>problem is with the Max(Fiscal Month) it looks at the max of the selected fiscal month</P><P></P><P>Thanks </P></BODY></HTML> Thu, 11 Dec 2014 08:11:22 GMT https://community.qlik.com/t5/QlikView/Creating-a-variable/m-p/812001#M286609 rido1421 2014-12-11T08:11:22Z Re: Creating a variable https://community.qlik.com/t5/QlikView/Creating-a-variable/m-p/812002#M286610 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Try : =Max({1} [Fiscal Month])</P><P></P><P>HTH</P><P>Sushil</P></BODY></HTML> Thu, 11 Dec 2014 08:25:46 GMT https://community.qlik.com/t5/QlikView/Creating-a-variable/m-p/812002#M286610 sushil353 2014-12-11T08:25:46Z