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: 
rishimessi19
Contributor II
Contributor II

Custom Dimension

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

4 Replies
sunny_talwar

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.

effinty2112
Master
Master

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',

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

Mark_Little
Luminary
Luminary

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

effinty2112
Master
Master

Typo Alert!