topic Re: Calculated dimension in QlikView

Calculated dimension

Wed, 25 Nov 2020 16:16:04 GMT

Hi Experts,

i want to display on current month's date in my dimension.

i have a variable set as vMTD = '>=' & Date(MonthStart(Today()-1)) & '<=' & Date(Today()-1)

How can i create a dimension in my straight table. Please help.

sunny_talwar — Mon, 15 Aug 2016 12:06:23 GMT

This variable looks more like a candidate for set analysis. Do you specifically wanted to use calculated dimension for current month?

Mon, 15 Aug 2016 12:11:43 GMT

Yes sunny please

I want only current month's dates in the chart excluding today.

Please help

sunny_talwar — Mon, 15 Aug 2016 12:16:10 GMT

I don't really understand if you want set analysis or calculated dimension, but I guess here are both options

1) Calculated dimension (Remember to select 'Suppress When Value Is Null')

If(DateField >= MonthStart(Today()) and DateField < Today(), DateField)

2) Set Analysis

Sum({<DateField = {"$(='>=' & Date(MonthStart(Today()), 'DateFieldFormatHere') & '<' & Date(Today(), 'DateFieldFormatHere'))"}>} Measure)

Tue, 16 Aug 2016 11:14:01 GMT

Thank u so much sunny