topic Re: Need to excludes values on date field in QlikView

Need to excludes values on date field

nevilledhamsiri — Wed, 25 Nov 2020 16:16:04 GMT

Hi!

Please check my loaded data of which month/year field takes value. How calculated dimension be applied to correct this as this goes as a dimension field!. Also appreciate if steps are properly laid down to correct through number tab!

Thanks

Neville

Excel used

BRANCH	MONTH/YEAR	MOTOR	NON_MOTOR	TOT_PREMIUM
RA	January-16	100,000	250000	350,000
RA	February-16	250,000	300000	550,000
RA	March-16	350,000	150000	500,000
RA	April-16	450,000	350000	800,000
RA	May-16	500,000	250000	750,000
RA	June-16	583,333	150000	733,333
RA	July-16	658,333	200000	858,333

Re: Need to excludes values on date field

Frank_Hartmann — Sun, 01 Oct 2017 08:23:28 GMT

whats the expected output?

please give some more precise information about what you want to achieve!

Re: Need to excludes values on date field

its_anandrjs — Sun, 01 Oct 2017 08:34:31 GMT

Share some sample data to have a look may be you ask for date field.

Re: Need to excludes values on date field

vishsaggi — Sun, 01 Oct 2017 15:02:36 GMT

Correct me are you trying to display your MonthYR as of Excel format like Jul-2016?

May be use this in your calculated dim:

= Date(YourMonthYrField, 'MMM-YYYY')

Re: Need to excludes values on date field

nevilledhamsiri — Sun, 01 Oct 2017 15:46:06 GMT

Dear Vishwarath,

Thanks, Your expression for date calculation did work! Does this treatment correct the value shown on the date field already loaded. It seems no. In fact it is the format what you suggested I had used. Like this(March-12). Please advice me on,

Isn't it possible to to adjust the date format on already loaded data?

Like what you propose = Date(YourMonthYrField, 'MMM-YYYY'), please rewrite all other formats so that I can use them later!

Thanks

Neville

Re: Need to excludes values on date field

nevilledhamsiri — Sun, 01 Oct 2017 15:48:18 GMT

Dear Vishwarath,

This is how it appears!

Re: Need to excludes values on date field

vishsaggi — Sun, 01 Oct 2017 15:58:17 GMT

You can have many different formats for the Date field. What format you are looking for? And what is the expression you are using for your Date.

= Date(YourdateField, 'DD/MM/YYYY')

= Date(YourdateField, 'MM/DD/YYYY') something like that.

Re: Need to excludes values on date field

nevilledhamsiri — Sun, 01 Oct 2017 16:06:36 GMT

What about the already loaded field. Can it be converted to the same format or need to omit & use the date field made through the expression?

Re: Need to excludes values on date field

vishsaggi — Sun, 01 Oct 2017 16:09:19 GMT

You can use the Date() function even though it is already have a loaded datefield. So Just use the date function on your datefield which you have already loaded. What format you want and what is the date field name.

= Date(youralreadyloadeddatefield, 'yourformat here')

Re: Need to excludes values on date field

nevilledhamsiri — Sun, 01 Oct 2017 16:15:37 GMT

Thanks Wishwanath very much. I will close the thread!

Neville

Re: Need to excludes values on date field

vishsaggi — Sun, 01 Oct 2017 16:27:57 GMT

NO problem. Just to correct you it is Vishwarath, so there is no N in my name.... 🙂

Re: Need to excludes values on date field

nevilledhamsiri — Sun, 01 Oct 2017 16:40:48 GMT

Sorry, I will correct it!

Neville

Re: Need to excludes values on date field

vishsaggi — Sun, 01 Oct 2017 17:40:22 GMT

Oh you don't need to be sorry. That's cool just correcting. 🙂