Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

dhavalvyas
New Contributor II

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
Esteemed Contributor

Re: Valuelist for 3 Dimensions

Hi,

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

dhavalvyas
New Contributor II

Re: Valuelist for 3 Dimensions

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
Esteemed Contributor

Re: Valuelist for 3 Dimensions

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

kaanerisen
Contributor III

Re: Valuelist for 3 Dimensions

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
New Contributor II

Re: Valuelist for 3 Dimensions

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
New Contributor II

Re: Valuelist for 3 Dimensions

InkedValueList_LI.jpg

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

kaanerisen
Contributor III

Re: Valuelist for 3 Dimensions

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
New Contributor II

Re: Valuelist for 3 Dimensions

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

Re: Valuelist for 3 Dimensions

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

Community Browser