topic Re: Positive representation in QlikView

Positive representation

Anonymous — Wed, 22 Feb 2012 17:40:50 GMT

Hello, I have this model where I have this "piramidal" chart made of bars, ones positive and the others negative. I want to make that value positive in the X axe of the char.

Besides, i have this =IF(IsNUll(getfieldselections (Mes)),Date(Date#(Max(Mes),'MM'),'MM'),num(month(date#(getfieldselections (Mes),'MMM'))) ) to get the max month if there is no selection at all. Now, I want to insert that into this set analysis =Count(DISTINCT{$<[TipoFecha]={'Periodo'}, [Sexo]={M}>}[Identificación afiliado]), is used to draw one side of the barchart.

Making a long story short, I want to use that conditional in the set analysis so when I don't have anything selected, the chart can show me the max month

Thanks

Positive representation

swuehl — Wed, 22 Feb 2012 18:19:25 GMT

Juan,

talking about the bar chart, you want to create something like a butterfly chart, right?

This is not an easy task in QV, but maybe this gives you some ideas:

community.qlik.com/message/145421

Stefan

Positive representation

deepakk — Wed, 22 Feb 2012 18:27:57 GMT

hi,

If you want to select by default Month, if there is no selection then you can try the below code.

Count(DISTINCT{$<[TipoFecha]={'Periodo'}, [Sexo]={M},Year={$(=Max(Year))},Month={$(=Max(Month))}>}[Identificación afiliado])

Deepak

Positive representation

Anonymous — Wed, 22 Feb 2012 19:50:09 GMT

I wans't able to use that with my model, I don't know if I'm missing something or what. Is there any explanation more clear?

Positive representation

Anonymous — Wed, 22 Feb 2012 19:52:11 GMT

How should I use the Year={$(=Max(Year))}, Month={$(=Max(Month)), shoul I have them predefined?

Positive representation

deepakk — Thu, 23 Feb 2012 06:01:57 GMT

hi,

Yes you need to have the Year(Date) as Year and num(Month(Date)) as Month in your a field in your Script

Deepak

Positive representation

Anonymous — Thu, 23 Feb 2012 14:20:19 GMT

ok, I've done that, but all the bars in the chart disappear.

I just need to have the max value of the month and year when there is nothing selected. I was trying with this expressions:

=IF(IsNUll(getfieldselections (Mes)),Date(Date#(Max(Mes),'MM'),'MM'),num(month(date#(getfieldselections (Mes),'MMM'))) ) for month (the variable is called mesFiltro)

=IF(IsNull(getfieldselections (Año)),Max(Año),getfieldselections (Año)) for year (the variable is called añoFiltro)

and then using them as variables, and in the chart expression using them as this:

=Count(DISTINCT{$<TipoFecha={'Periodo'}, [Sexo]={M}, Mes=mesFiltro, Año=añoFiltro>}[Identificación afiliado]) for the right side of the chart

=-Count(DISTINCT{$<TipoFecha={'Periodo'}, [Sexo]={F}>}[Identificación afiliado]) for the left side of the chart

too difficult?

Positive representation

deepakk — Thu, 23 Feb 2012 17:07:00 GMT

hi,

Can you attach a sample file..

Deepak

Re: Positive representation

Anonymous — Fri, 24 Feb 2012 12:50:13 GMT

It's kind of big the file, mmm and I have tried some thing in the scripts but no answer

I attached it, finally.

Positive representation

deepakk — Fri, 24 Feb 2012 14:41:58 GMT

hi,

I got your problem.. you can create a single Yearmonth variable.

If you are creating a single yearmonth variable then u need to have a yearmonth field in the script as

Year(TempDate) & num(Month(TempDate),'00') as YearMonth

variable will be as follows

vYearMonth = if(getselectedcount(Año) =0,Year(today())&num(month(today()),'00'),Max(YearMonth))

and use this variable in the expression

Count({$<YearMonth={$(vYearMonth)}>}[Identificación afiliado]))

I hope this solve your problem.

Deepak

Re: Positive representation

Anonymous — Fri, 24 Feb 2012 15:54:00 GMT

That was perfect!!! Thank you a lot. Now in that file, I have a Butterfly chart where I want to use that variable, in order to show me the information of the current year/month if nothing is selected. But when I do that and then select feb/12 or leave it with no selection (it should take feb/12), the values change.

And I want also to check in the other tab, where is a block chart, the "Otros" section doesn't show the percentage, intead it shows a decimal.

Thank you thank you thank you!!!

Positive representation

deepakk — Fri, 24 Feb 2012 16:48:23 GMT

HI,

I thinkk the blcok chart issue will be solved using the relative option . You will find it in Exoression tab , below the enable tab.

I didnt get your butterfly issue. Can you specify the tab and the report name. If you can add a snap shot then it would be grt..

I can't understand the language inside the application

Deepak

Re: Positive representation

Anonymous — Mon, 27 Feb 2012 14:27:28 GMT

The relative option is not working as I want to.

I check the relative box, and all the data is showed as % but the "Otros" section.

Positive representation

deepakk — Tue, 28 Feb 2012 06:05:38 GMT

hi,

Can you attach some snap shot to show what exactly you require.

Deepak