Series Excel function into Qlik

[prma7799]

Hi All,

What is an alternative option for SERIES excel function in Qlik.

I have below excel formula that need to incorporate in QlikSense chart.

=Series('Data'  !$D8$ , 'Data'  !$F7$:$A7$ , 'Data'  !$F9$:$K9$ , 1)

=Series("Deep", , 'Pride' !$I3$:$M3$ ,2) 

Thanks

[Kushal_Chawda]

@prma7799   looking at just formula won't help. Provide some sample data with expected output

[sunny_talwar]

@prma7799 I don't see any function as Series in Excel by default. Do you have an add-on of some sorts?

[Almen · Accepted solution]

The Series() function creates a bar chart in Excel but in Qlik you can't do that via script. Just use the Visualisation objects of Qlik.