topic Re: show only chosen month for two different date fields. But the month field is created from one of the date fields in Reporting Service & Alerting

show only chosen month for two different date fields. But the month field is created from one of the date fields

arunqlik2view — Fri, 15 Nov 2024 22:07:41 GMT

Hello All,

I have 2 dates fields "Date" and " TransactionDate". Now, I have a month field created for "date" column. So when I choose month from the listbox it forces to show all the rows for that particular month , which is normal but it also shows the previous month's value in the "Transaction Date" just because the "date" is still current month selection.
I'm sorry if this is sound confusing. Please do check the below image for more detail, it will easy for you understand once you have a look .

Please tell how this can be achieved I have attached the sample qlikview file for you to work it out.

Re: show only chosen month for two different date fields. But the month field is created from one of the date fields

edwin — Tue, 05 Jul 2022 17:29:24 GMT

you should post this in the QlikView section

Re: show only chosen month for two different date fields. But the month field is created from one of the date fields

arunqlik2view — Wed, 06 Jul 2022 03:15:27 GMT

I HAve reposted in the Qlikview section. Sorry for the trouble . I tried to delete here but it seems there is no option.
Kindly have the forum moderator to delete it here.