Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
prma7799
Master III
Master III

Series Excel function into Qlik

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

 

Labels (1)
1 Solution

Accepted Solutions
Almen
Creator II
Creator II

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.

View solution in original post

3 Replies
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
Creator II
Creator II

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.