topic Re: Count if (field is like field) in QlikView

Count if (field is like field)

Montanarin — Thu, 24 Sep 2020 10:13:35 GMT

hi all,

i need to show a bar chart that counts the fault code, for example field (guasti) could be '19', of course it could contains many faults like ('23,19,15'). So i need count how many times each field is presents, itself or into a more complex strings.

see my sample below

thank you

Re: Count if (field is like field)

Kushal_Chawda — Thu, 24 Sep 2020 10:45:17 GMT

@Montanarin do you want to do it in script or front end?

Re: Count if (field is like field)

Montanarin — Thu, 24 Sep 2020 12:12:19 GMT

Hello Kush, i would like just to have a chart; of course if just Script solution can solve it, alright.

Re: Count if (field is like field)

Kushal_Chawda — Thu, 24 Sep 2020 12:42:56 GMT

@Montanarin If I understood it correctly. Do you need this?

Below is the data

Create chart with below dimension and measure

// Dimension =ValueList($(=concat(DISTINCT guasti,','))) //Measure =SubStringCount(concat(DISTINCT total guasti,','), ValueList($(=concat(DISTINCT guasti,','))))

Re: Count if (field is like field)

Kushal_Chawda — Thu, 24 Sep 2020 12:50:21 GMT

@Montanarin script solution will go like below

Data:
LOAD guasti,
SubField(guasti,',') as guasti_all
FROM Table;

Then create a chart with Dimension guasti_all and measure count(guasti_all)

Re: Count if (field is like field)

Montanarin — Thu, 24 Sep 2020 13:03:42 GMT

perfect... many thanks.

What about translate an "enum" to "guasti" number. i.e. 23 means "engine".