Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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...
Hi,
did you try ValueList('Dimension1','Dimension2','Dimension3') ?
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...
would you be able to share sample data which will represents your actual data structure ?
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,
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..
Like this All the Companies are Shown in Stacked as per its Percentage..
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)
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..?
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