Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

agrimroquette
Valued Contributor

how can we group values?

i have this data i want to see count of different phases vs % classification as 0-25%, 26-50%,51-75%, 76-100%

1 Solution

Accepted Solutions
vishwa_461
New Contributor III

Re: how can we group values?

Hello Agrim,

I have made few changes to the expression in the chart. please find the below attachment. I have got the result as below. See if it can help you. QVW is attached below.

chart.JPG

33 Replies

Re: how can we group values?

Are you using a crosstable load?

agrimroquette
Valued Contributor

Re: how can we group values?

thanks a lot for your kind reply,

No,

i have encountered an error, chart is not showing actual count of values. please help

i have used this script

LOAD

    "NAME OF PROJECT (Code)" ,

    Phase,

    "Opportunity Phase Completion %" as Classification ,

    "Global Weather Situation"

FROM [lib://PPM/Project Portfolio - New.xlsx]

(ooxml, embedded labels, table is [Project Status]);

concatenate

LOAD

    "NAME OF PROJECT (Code)",

  Phase,

      "Feasibility Phase Completion %" as Classification,

      "Global Weather Situation",

  

FROM [lib://PPM/Project Portfolio - New.xlsx]

(ooxml, embedded labels, table is [Project Status]);

concatenate

LOAD

    "NAME OF PROJECT (Code))" ,

    Phase,

      "Project Phase Completion %" as Classification,

    "Global Weather Situation",

  FROM [lib://PPM/Project Portfolio - New.xlsx]

(ooxml, embedded labels, table is [Project Status]);

Formula for making ratio:-used in bar chart

Dimension 1

Phase

Dimension 2

IF ([Classification] <= 0.25 , '0-25' ,

IF ([Classification]  >= 0.26 and  [Classification] <= 0.50,  '26-50%',

IF ([Classification]  >= 0.51 and  [Classification] <= 0.75,  '51-75%',

IF ([Classification]  >= 0.76 and  [Classification] <= 1,  '76-100%',

'Null'))))

Measure 1

count({$<Phase={ 'Project', 'Opportunity' , 'Feasibility' }>} distinct  [NAME OF PROJECT (Code)] )

problem is bar chart its showing wrong values.

Re: how can we group values?

Why do you think they are wrong values? Would you be able to share your qvf if you have already created one for the sample data provided? It will save me time

agrimroquette
Valued Contributor

Re: how can we group values?

yes i am sending please wait

agrimroquette
Valued Contributor

Re: how can we group values?

please accept my follow request if possible

Re: how can we group values?

I have already done that

Re: how can we group values?

Why do you think the numbers are wrong? Would you be able to share the correct numbers for this chart?

agrimroquette
Valued Contributor

Re: how can we group values?

all the 'Projects' are 37 in total but its showing in '75-100%' only the count of 'feasibility' is coming correct

agrimroquette
Valued Contributor

Re: how can we group values?

i added my dashboard(.qvf) and data file can you please check it out? i will be very thankful