Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

ruma_barman
Contributor

Showing all keys for the current fiscal year on selection of monthyear

Hi All,

I have a requirement to find rate .If I select a monthyear all the keys(key field) of the current year should give rate.But the rate should be of highest monthyear.

For E.g if this is the data:

Key,Date,Rate

1,22/08/2017,11

2,22/08/2018,12

2,22/07/2018,13

3,22/07/2018,14

On selection of  Aug'18 The output should be

Key,Rate

2,12

3,14

On selection of  Jul'18 The output should be

Key,Rate

2,13

3,14

5 Replies
qlikmeplease
Contributor III

Re: Showing all keys for the current fiscal year on selection of monthyear

On selection of Jul18 it is working, but why would Aug18 return 12 and 14 when the rate of 14 is not in the August month?

Please explain what you are expecting, because the results are correct.

ruma_barman
Contributor

Re: Showing all keys for the current fiscal year on selection of monthyear

Hi Ruan,

Since key 3 belongs to that fiscal year.All the keys of the selected fiscal year should give rate.If it isn't present in selected monthyear,it should show the rate of last monthyear.

jyothish8807
Honored Contributor II

Re: Showing all keys for the current fiscal year on selection of monthyear

Hi Ruma,

In that case the output for Aug'18 also should be below:

Key,Rate

2,13

3,14

Br,

KC

Best Regards,
KC
ruma_barman
Contributor

Re: Showing all keys for the current fiscal year on selection of monthyear

Hi Jyothish,

If the Key is present in current selection month,it should give the rate of that month.

ruma_barman
Contributor

Re: Showing all keys for the current fiscal year on selection of monthyear

Morever if a key is not present in Aug'2018(if  Aug'2018 is selected) and present in both Jun'2018 & Jul'2018 ,it should give rate of Jul'2018