topic Re: Custom Dimension in QlikView

Custom Dimension

rishimessi19 — Thu, 10 Dec 2015 17:28:51 GMT

- I have a Dimension which has values - {OC, FR, CFP, FC, PR, HK,............)

- There is no value 'Joint OC / FR' (marked in RED) in the dimension.

- I am having an expression as count(XYZ)

Question:

- Can I get a new value in the dimension 'Joint OC and FR' (it is basically the sum of OC and FR) marked as RED and also 'Others'

*** I have tried out resident load, renaming the column values and concatenating it with the source table. But, Here the issue is that I am getting duplicate records related to OC and FR which will impact other calculations on the dashboard.

Re: Custom Dimension

sunny_talwar — Thu, 10 Dec 2015 17:39:36 GMT

Difficult to understand what you are trying to do. May be if you are able to share a sample with your expected output, it would be much easier to help.

Re: Custom Dimension

effinty2112 — Wed, 16 Dec 2015 13:51:27 GMT

Hi Rishi,

Try this as a calculated dimension in your chart. You may need to add more field values to this if there are more values of your field than are in this script.

=Pick(

match(

FieldName,

'OC',

'FR',

'CFP',

'FC',

'PR',

'HK'),

'OC / FR',

'CFP',

'FC',

'PR',

'HK')

If you want to group other field values as 'Other' add them to the Match expression and add the same number of 'Other' lines to the Pick expression that wraps it. Be careful to have the 'Other' lines in places corresponding to the values in the match statement that you want to be grouped as 'Other'.

Re: Custom Dimension

Mark_Little — Wed, 16 Dec 2015 14:00:21 GMT

HI,

Another option is using a expression for each bar.

Count({<FieldName={'OC','FR'}>}FieldName)

Count({<FieldName={'CFP',}>}FieldName)

Then label how every you like

//edit - Well the typo was certainly a good one!

Mark

Re: Custom Dimension

effinty2112 — Wed, 16 Dec 2015 14:10:25 GMT

Typo Alert!