Discussion Board for collaboration related to Creating Analytics for QlikView.
I am creating a table where I would like a column to show a Monthly calculation if a single month is selected. If no month or multiple months are selected, this column should show nulls.
Can anyone help with syntax for something like this? I'm presuming I would add it to the 'Conditional' box for expressions?
Thanks very much.
Go to Solution.
Try this in your Expression. Hope it helps you.
May be simply a conditional expression like:
Yes, you are right.
You can write the general expression for calculation and then Force the Chart to be displayed on the selection of a Distinct Month Value as tresesco has suggested i.e.