Creating new field in dashboard

[Lucky1]

Hi team,

I have to create one column in dashboard based on my data.

I/p table

ID  coss Markets M1  M2 M3 M4...M20 Secure S1 S2 S3 

1.      ×

2.                   ×

3.                   ×.         ×

4.                   ×.         ×.                 ×

5.                   ×.        ×.      ×.                                ×

My o/p looks like

ID              Impati

1.              Coss

 2         Markets

3          Markets: M1

4            Markets: M1,M4

5.          Markets: M1,M2& Secure 

I want to show names where we have ×

How can I achieve this

[Mark_Little]

Hi, 

I reckon you will be best looking at this in script and your the Cross table Function.

https://help.qlik.com/en-US/qlikview/May2022/Subsystems/Client/Content/QV_QlikView/Scripting/ScriptP...

You should be able then get it usable data and display as you require.

[Lucky1]

Hi Mark thanks for your reply.i have used cross table function but Iam unable to write logic.can u please help me on this.can u take this example and try it how to write logic.Its much needed Iam struggling alot