topic Re: Set Analysis two QV Functions in QlikView

Set Analysis two QV Functions

NickHoff — Tue, 17 May 2016 19:19:35 GMT

This one should be easy, i'm just struggling with the correct syntax.

I have the following set which works correct:

=Count(DISTINCT {$<SurgicalSupplyItemCode = {"=LEN(SurgicalSupplyItemCode) = 6"}>}

I'm looking to add the following to it

IsNum(SurgicalSupplyItemCode)<>0

I've tried the following:

=Count(DISTINCT {$<SurgicalSupplyItemCode = {"=LEN(SurgicalSupplyItemCode) = 6"},IsNum(SurgicalSupplyItemCode)<>0 >} SurgicalSupplyItemCode)

=Count(DISTINCT {$<SurgicalSupplyItemCode = {"=LEN(SurgicalSupplyItemCode) = 6"},IsNum(SurgicalSupplyItemCode)-=0 >} SurgicalSupplyItemCode)

=Count(DISTINCT {$<SurgicalSupplyItemCode = {"=LEN(SurgicalSupplyItemCode) = 6"},{"IsNum(SurgicalSupplyItemCode)<>0"} >} SurgicalSupplyItemCode)

trdandamudi — Tue, 17 May 2016 19:21:25 GMT

May be this:

=Count(DISTINCT {$<SurgicalSupplyItemCode = {"=LEN(SurgicalSupplyItemCode) = 6"},IsNum(SurgicalSupplyItemCode)<>{0} >} SurgicalSupplyItemCode)

NickHoff — Tue, 17 May 2016 19:24:05 GMT

Gives error in expression by the <> i switched to -= and still same thing

sunny_talwar — Tue, 17 May 2016 19:26:49 GMT

May be this:

=Count(DISTINCT {$<SurgicalSupplyItemCode = {"=Len(SurgicalSupplyItemCode) = 6 and IsNum(SurgicalSupplyItemCode) <> 0"}>} SurgicalSupplyItemCode)

=Count(DISTINCT {$<SurgicalSupplyItemCode = {"=Len(SurgicalSupplyItemCode) = 6 and IsText(SurgicalSupplyItemCode)"}>} SurgicalSupplyItemCode)

NickHoff — Tue, 17 May 2016 19:27:30 GMT

Thanks Sunny! Didn't realize i could use AND int the SET.

sunny_talwar — Tue, 17 May 2016 22:24:35 GMT

This is a search string where we are checking if the two conditions are met. This is a little different from the regular set analysis we use.