I need to display the # record based on ID but horizontal bar chart should display the Name

[Sai78]

Case Number	Id	Name
111	1	test 1
112	2	test 2
113	3	test 3
114	4	test 1
115	5	test 2
116	6	test 3
117	7	test 7
118	8	test 8
119	9	test 9
120	10	test 10
121	11	test 11

I need to display the # record based on ID but horizontal bar chart should display the  Name

• I created dimension as name and Expression =Count( DISTINCT (Case Number)) .. can you help how to display the value by id and display the bars by name

[Lech_Miszkiewicz · Accepted solution]

Hi,

you can create in your script DUAL() field using text and Id. If your ID is not a number apply "Autonumber function on it like this: Dual(Name,Autonumber(Id,'Id')) as DualName

Load 
   *,
   Dual(Name,Id) as DualName
   Inline
   [
   Case Number,Id,Name
    111,1,test 1
    112,2,test 2
    113,3,test 3
    114,4,test 1
    115,5,test 2
    116,6,test 3
    117,7,test 7
    118,8,test 8
    119,9,test 9
    120,10,test 10
    121,11,test 11

   ]
   ;

then in your chart you can use DualName as dimension. My example is built in Qlik Sense but it will work the same in QlikView

[Sai78]

This worked .. thanks

[Lech_Miszkiewicz]

Please mark correct answer as “solution” then