Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have a field dimension that can have about 7 distinct values.
Say Value 1 ---Value7.
I have a set analysis expression where I need to include just 2 values from the specific field, say 'Value 1' and 'Value 2'. The scenario is that one of the value ('Value 1') exists in the data loaded but the other doesn't exist(at least at the moment but can be available in future loaded).
MY expression is:
COUNT({<[RE.Rating]={'Value 1','Value 2'}>}[RE.D])
Dimension selected is [RE.Rating]
So I would expect the resultant chart to show only the count for 'Value 1' as 'Value 2' doesn't exist. But it shows count of all the existing values.If I just have 'Value 1' in the expression then it shows just count for this. When I include just 'Value 2' in expression is shows all the values again when I want it to show nothing.
Am I missing something here.
Appreciate any advice on this.
Thanks.
Ok build 12123 had a bug with Set Analysis. Go to the download section and get the latest build 12129
Just for information the values in the field can be:
'Not Formally Rated - Satisfactory'
'Formally Rated - Satisfactory'
'Not Rated'
'Not Formally Rated - Less Than Satisfactory'
'Formally Rated - Less Than Satisfactory'
'Formally Rated - Not Satisfactory' ----This value is not in the data loaded at the moment but can exist in future loads.
Hi Amit,
Please have a look at the attached application and see if its correct and solves your problem.
Kind Regards
Jason
Hi Jason,
Thanks for getting back. This is what I see when I bring up your file. This is exactly the issue I am having. In your expression too you are filtering on 2 values but you are still able to see all the values even though they should not be appearing.
Rgds.
Hi Amit,
I see the problem, What version of QlikView are you using? I am runnnig 11.20 SR4 update 2 and all is working fine.
HI Jason,
I am using Version 11.20.12123.0 SR4 64 bit version.
Rgds,
Amit.
Ok build 12123 had a bug with Set Analysis. Go to the download section and get the latest build 12129
Super. Updated and it works now.
Thanks a lot Jason.
You are most welcome