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: 
dhavalvyas
Contributor III
Contributor III

Valuelist for 3 Dimensions

Hi,

I am trying to Implement Value List in Qliksense. I have Mainly 3 Dimensions in it. How we can use 3 Dimensions in Valuelist..?

Thanks in Advanced... 

9 Replies
YoussefBelloum
Champion
Champion

Hi,

did you try ValueList('Dimension1','Dimension2','Dimension3')  ?

dhavalvyas
Contributor III
Contributor III
Author

Yes,

But my Exact Requirement is I have to show Market Share for YTD - 2017 and YTD - 2018  for all Private Sector Insurance Company.

Inside Private Sectors Company there is Mainly 6 Companies in it.

I want Two Bars only with YTD - 2017 and YTD -2018 with all the Private Sectors Comapnies (6 Companies) in Stacked for both Bars..?

If it Possible in Some Other Charts the Please Recomend me..

Thanks in Advanced... 

YoussefBelloum
Champion
Champion

would you be able to share sample data which will represents your actual data structure ?

kaanerisen
Creator III
Creator III

Hi Dhaval,

Object: Bar Chart

Dimension : Valuelist('YTD - 2017','YTD -2018')

Measure : Pick(

                    Match(Valuelist('YTD - 2017','YTD -2018'),'YTD - 2017','YTD -2018'),

                    Sum({<Set Analysis Expression for YTD -2017>}Measure),

                    Sum({<Set Analysis Expression for YTD -2018>}Measure)

                    )


If you want to show this values as stacked in a bar, you should use this dimension as second. First dimension values will be bars and second dimension values will be stacked.


Hope it helps,

dhavalvyas
Contributor III
Contributor III
Author

Hi,

Kaan but I want to Show all the Private Sector Companies in Stacked...There are mainly 6 Companies in it...So we have to Add Private Companies also in Dimension..

dhavalvyas
Contributor III
Contributor III
Author

InkedValueList_LI.jpg

Like this All the Companies are Shown in Stacked as per its Percentage..

kaanerisen
Creator III
Creator III

Then first dimension will be valuelist and second dimension will be companies.

Dimension1 : Valuelist('YTD - 2017','YTD -2018')

Dimension2 : Companies

If you want to show the percantage, measure should be:

Measure : Pick(

                    Match(Valuelist('YTD - 2017','YTD -2018'),'YTD - 2017','YTD -2018'),

                    Sum({<Set Analysis Expression for YTD -2017>}Measure) / Sum({<Set Analysis Expression for YTD -2017>} total Measure),

                    Sum({<Set Analysis Expression for YTD -2018>}Measure)/  Sum({<Set Analysis Expression for YTD -2018>} total Measure)

                    )


You can add company filter to measures' set analysis. For example,

Sum({<CompanySectorType={'Private'},...>}Measure)

dhavalvyas
Contributor III
Contributor III
Author

Thanks kaan It Works but I want Values Inside Bar for Each Company Values,How can I do it..?

Is there is any Editing in Back End Script of Bar Chart..?

kaanerisen
Creator III
Creator III

For now ,standart bar chart object doesn't have an option to satisfy your requirement. Maybe you can find an extension from branch.

http://branch.qlik.com/#!/project/57161998713777448667b063

Please mark the "Correct Answer" If the post above is working for you. it will helpful for some people