Hi @ajith_qlik
Everything depends on your data model.
Loading 2 fields from inline may work differently if :
- those fields are connected to your data model or
- are not linked to your data model (lets call it "island tables")
judging by what you have described 1st option is not in place and as general rule it is not great. It means that you have tables not associated with each other in your data model and it may have huge implications on the performance of your app if you load it with large data volume
assuming you are having Island tables in your model for Year and Month and you want to use those for your selections you need to have a fields you want to compare those values to in your fact table or rest of your mode. Normally you would have some sort of date field and what you want to do is to derive during load script from that date field columns for Month and Year. Normally you would do it by use of following functions:
Year(YourDateField) as Year_Key,
Month(YourDateField) as Month_Key,
Now when you have those 2 new fields created you can now start using them in your expressions like in charts like:
Sum({<Year_Key=P(Year),Month_Key=P(Month)>}Sales)
Now what I dont understand is what you are saying here:
...The issue is when I am selecting 2019 and then March, all the 3 years are selected for March and shown in the report, whereas I just need to show only March values for only 2019 in the report..
Based on the fact that you have no associations between your model and "filter year and month" fields when selecting Year=2019 and Month=March your report in your current state should show unfiltered data because as you are saying there is no association. If selection is already filtering data it means that your description above is not giving us full information.
In the expressions I mentioned above I create the associations in them by using set analysis and P (possible) function. There are also other ways of handling it, but this one is good to show you how it works. So the concept is that by having Year_Key and Month_Key fields created and associated in your model now you can pass on them selections using set analysis and P function.
If you need more detailed explanation I suggest you attach a sample and provide more detail description of how it needs to work, limitations you may have and reasons why you have chosen to go with the island table approach.
cheers
cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.
