Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
arunqlik2view
Creator
Creator

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

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  . 

arunqlik2view_0-1657028540412.png

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

Labels (1)
  • Date

2 Replies
edwin
Master II
Master II

you should post this in the QlikView section

arunqlik2view
Creator
Creator
Author

 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.