topic Re: Set expression issue..?? in QlikView

Set expression issue..??

vishalgoud — Wed, 25 Nov 2020 16:16:04 GMT

Team ,

we have 5 tables and each tables is having a separate flag field, so that we can differentiate and compare the data together,remianing all columns are common in all 5 tables and we are concatinating all into a single fact. in the below expression Flag_EE is from table EE.

sum({<Flag_EE={1},[Call Type]={Voice}>} $(vShowDurationAs))

is my above expression is right to get the data from a single table where Flag_EE =1 is the defualt value we are giving in that table.

and call type and $(vShowDurationAs coming from over all fact table which is a combination of all 5 tables..

Now i want to get the data from the table 5 where the flag is Flag_EE, am i using the correct set exp ???

please advise..

Re: Set expression issue..??

sunny_talwar — Mon, 22 Jan 2018 10:28:28 GMT

Looks right to me... is it not working?

Re: Set expression issue..??

vishalgoud — Mon, 22 Jan 2018 10:38:56 GMT

it is working Sunny, But business was saying that the counts are coming from all the tables not from a single EE table where i was bit confused.

in the set modifiers whatever we mention then the set expression pick the resultant counts only right ??

in the Qvd we are taking 1 as Flag_EE and am using Flag_EE={1} which is correct only right ??

Re: Set expression issue..??

sunny_talwar — Mon, 22 Jan 2018 10:41:55 GMT

As far as I know and understand, what you are saying is correct. If you have flagged a single table with 1, and you use it in your set analysis, then it should show you the count from that table only. May be someone else can verify me here. pcammaert‌

Re: Set expression issue..??

Clever_Anjos — Mon, 22 Jan 2018 11:09:28 GMT

You´re right stalwar1‌, as usual

vishalgoud,please elaborate a bit more what you mean by

"vShowDurationAs coming from over all fact table which is a combination of all 5 tables"

Re: Set expression issue..??

Peter_Cammaert — Mon, 22 Jan 2018 12:23:47 GMT

It probably depends on how the table containing Flag_EE links to the central table, if I understand it right that the common data is residing in a central table.

To be absolutely sure that no other records are used when a particular flag is chosen, it may be better to throw everything together and add a single Flag that contains values identitying the different sources (Set analysis then becomes Flag={EE} or something). If possible.