Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Lucky1
Creator
Creator

Creating new field in dashboard

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

 

 

 

 

 

 

Labels (4)
2 Replies
Mark_Little
Luminary
Luminary

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
Creator
Creator
Author

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