topic Re: Valuelist for 3 Dimensions in Visualization and Usability

Valuelist for 3 Dimensions

dhavalvyas — Tue, 10 Apr 2018 06:54:33 GMT

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...

Re: Valuelist for 3 Dimensions

YoussefBelloum — Tue, 10 Apr 2018 07:11:16 GMT

Hi,

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

Re: Valuelist for 3 Dimensions

dhavalvyas — Tue, 10 Apr 2018 07:30:53 GMT

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...

Re: Valuelist for 3 Dimensions

YoussefBelloum — Tue, 10 Apr 2018 07:36:26 GMT

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

Re: Valuelist for 3 Dimensions

kaanerisen — Tue, 10 Apr 2018 08:09:14 GMT

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,

Re: Valuelist for 3 Dimensions

dhavalvyas — Tue, 10 Apr 2018 09:15:01 GMT

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..

Re: Valuelist for 3 Dimensions

dhavalvyas — Tue, 10 Apr 2018 09:30:50 GMT

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

Re: Valuelist for 3 Dimensions

kaanerisen — Tue, 10 Apr 2018 10:25:03 GMT

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)

Re: Valuelist for 3 Dimensions

dhavalvyas — Tue, 10 Apr 2018 11:26:17 GMT

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..?

Re: Valuelist for 3 Dimensions

kaanerisen — Tue, 10 Apr 2018 12:36:24 GMT

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