Qlik Community

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.
tiklam_dynasys
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

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

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])

tiklam_dynasys
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

tiklam_dynasys
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!

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])