Qlik Sense Table - conditional content

[Anonymous]

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

[ahaahaaha · Accepted solution]

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

[Anonymous]

Hi Andrey,

this works just fine!

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