topic Re: sorting in a bar chart in QlikView

sorting in a bar chart

Mon, 16 Feb 2015 10:30:31 GMT

hello all,

first question :

i have a bar chart which has 13 months of data , i need to sort values according to last 12 months of data .

second querstion :

i have defects : p1 to p4 , how do i sort data in below order

Third question :

Mon, 16 Feb 2015 10:36:29 GMT

Can you post sample qvw with some dataset?

thanks

Peter_Cammaert — Mon, 16 Feb 2015 10:40:27 GMT

1st answer: use set analysis to reduce the bar chart scope to the last 12 months. BTW what is your first dimension?

2nd answer: sort the defect category dimension Z->A (text)

3rd answer:

Mon, 16 Feb 2015 11:08:53 GMT

Hi peter first dimension is
defect category , first column in table

second answer it is working thanq ,

3rd anwer :

i have a graph . where i am using terc_closing date as dimension

and expression i am evaluating for each terc_defect category

for example for code, i am writing an expression and

for application configuaration i am writing an expression

, i am getting the below graphs

i want months to be for last 12 months , since this monthe is feb

i want

the last graph is the right sort order, i am giving sort expression as

count({<terc_defect category ={"$(vperviousmonth)")>}terc_defect category