topic Re: Qlik Sense Table - conditional content in Integration, Extension & APIs

Qlik Sense Table - conditional content

Anonymous — Fri, 05 May 2017 11:33:41 GMT

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 — Fri, 05 May 2017 13:37:35 GMT

Hi Marco,

If this is in script, then

LOAD

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 — Mon, 08 May 2017 08:04:38 GMT

Hi Andrey,

this works just fine!

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