topic Re: Flagging reoccurring value in App Development

Flagging reoccurring value

Mt3 — Mon, 31 Jan 2022 14:36:17 GMT

Hi,

How can we highlight in QlikSense variables that have already been assigned to another value?

Exemplary, in FieldName we have Field1, Field2, Field3. If a Value of 1 have already appeared in Value column and has been assigned to Field1, i would like to highlight it when it appears again and is assigned to Field2 this time.

Its aimed to be a chart feature (table).

Re: Flagging reoccurring value

Taoufiq_Zarra — Tue, 01 Feb 2022 09:06:13 GMT

@Mt3

Maye be like :

Data: load *,rowno() as ID inline [ FieldName,Value Field1,1 Field2,1 Field1,2 Field1,2 Field3,4 Field1,3 Field3,3 ]; left join load Value,count(distinct FieldName) as FieldNameFlag resident Data group by Value; output: noconcatenate load *,if(peek(FieldNameFlag)>1 and peek(Value)=Value,'assigned','not assigned') as Flag resident Data order by Value,ID; drop table Data; drop fields FieldNameFlag;

output:

Re: Flagging reoccurring value

Mt3 — Tue, 01 Feb 2022 12:04:58 GMT

Thank you @Taoufiq_Zarra !

Do you think such effect would be possible to achieve on chart level directly, without data re-load?

Re: Flagging reoccurring value

Taoufiq_Zarra — Tue, 01 Feb 2022 14:27:22 GMT

@Mt3 I don't think so, or I have no idea 🙂

Re: Flagging reoccurring value

jbhappysocks — Tue, 01 Feb 2022 14:43:08 GMT

Hello

Second version of this answer, might have misunderstood exactly how you wanted Values to be assigned to FieldNames. But IF you want it based on script loadorder, ie the first loaded combination of FieldName and Value is what we want to assign, not the lowest for example, then you can use Aggr.

The exact aggregation here is not important, it's just the fact that the result will be displayed on the first loaded row. The idea is shown in the last two columns here.

Re: Flagging reoccurring value

MarcoWedel — Tue, 01 Feb 2022 17:50:16 GMT

another solution might be:

table1: Load RecNo() as RecID, *, If(AutoNumber(FieldName,Value)>1,1,0) as Reoccurred Inline [ FieldName, Value Field1, 1 Field2, 1 Field1, 2 Field1, 2 Field3, 4 Field1, 3 Field3, 3 ];

hope this helps

Marco