Qlik Community

Qlik Sense Integration, Extensions, & APIs

Discussion board where members can learn more about Integration, Extensions and API’s for Qlik Sense.

mrchmchr
New Contributor II

Qlik Sense Table - conditional content

Hi,

I am trying to add a Table Chart to my app where only certain rows are shown.

(Content of column X shall be displayed where values in column Y exceed a certain threshold.)

Therefore I tried to add a condition in the "Add column" menu in the data section.

I already tried:

IF(Y>0.05,X)

{<Y={>0.05}>}X

but both failed. Am I missing something or is this not possible in Qlik.

Thanks and kind regards,

Marco

1 Solution

Accepted Solutions
ahaahaaha
Honored Contributor

Re: Qlik Sense Table - conditional content

Hi Marco,

If this is in script, then

LOAD

X,

Y

FROM [Path to file]

Where Y> 0.5;


If this is in front (in chart), then


Dimension: X


Expression: Sum({<X={"=Y>0.5"}>}Y)


See attached file


Regards,

Andrey

2 Replies
ahaahaaha
Honored Contributor

Re: Qlik Sense Table - conditional content

Hi Marco,

If this is in script, then

LOAD

X,

Y

FROM [Path to file]

Where Y> 0.5;


If this is in front (in chart), then


Dimension: X


Expression: Sum({<X={"=Y>0.5"}>}Y)


See attached file


Regards,

Andrey

mrchmchr
New Contributor II

Re: Qlik Sense Table - conditional content

Hi Andrey,

this works just fine!

большое спасибо

Community Browser