# Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Contributor

## How to set Analysis with Field value exist in other column?

Table 1:

Field AField B
A10
B20
C30
D50

Table 2:

Field CField D
A1
B2
D3
E4

How to set an analysis like below where Table 1 and Table 2 are not associated together?

Count (distinct (if(Field B > 0 and (Field A exist in Field C), [Field B])))

Many Thx!

1 Solution

Accepted Solutions MVP

## Re: How to set Analysis with Field value exist in other column?

That is strange because not having anything there is equivalent of having \$ (unless you chart is in an alternate state). So essentially these two equations are the same Count(DISTINCT {<[Field B] = {'>0'}, [Field A] = P([Field C]>} [Field B])

Count(DISTINCT {\$<[Field B] = {'>0'}, [Field A] = P([Field C]>} [Field B])

4 Replies MVP

## Re: How to set Analysis with Field value exist in other column?

May be this:

Count(DISTINCT {<[Field B] = {'>0'}, [Field A] = P([Field C]>} [Field B])

Contributor

## Re: How to set Analysis with Field value exist in other column?

Hi Sunny,

it seems not work.

Does It only allows putting value in P(Value) instead of P(Field)?

Best Regards

Contributor

## Re: How to set Analysis with Field value exist in other column?

It works after adding the \$

Count(DISTINCT {\$<[Field B] = {'>0'}, [Field A] = P([Field C]>} [Field B])

THX! MVP

## Re: How to set Analysis with Field value exist in other column?

That is strange because not having anything there is equivalent of having \$ (unless you chart is in an alternate state). So essentially these two equations are the same Count(DISTINCT {<[Field B] = {'>0'}, [Field A] = P([Field C]>} [Field B])

Count(DISTINCT {\$<[Field B] = {'>0'}, [Field A] = P([Field C]>} [Field B])

Community Browser