Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
vandrecarlos
New Contributor II

Error Converting a Table to Graphs

Hello,

 

I'm having an issue during the conversion of a measure that works on his minimum level to a graphic where I want to group them.

 

That is the measure:

 

IF((MAX([Data doc.faturamento p/índice de docs.faturamto.e impressão - (VBRK-FKDAT)]))>=(TODAY()-120),'ATIVO','INATIVO')

 

And I have these two that are just the separation of "Ativo" and "Inativo"

 

Ativo:

IF((MAX([Data doc.faturamento p/índice de docs.faturamto.e impressão - (VBRK-FKDAT)]))>=(TODAY()-120),COUNT(distinct([Cliente emissor da Ordem de Vendas - (VBAK-KUNNR)])),'0')

 

Inativo:

Count(distinct([Cliente emissor da Ordem de Vendas - (VBAK-KUNNR)]))

-

IF((MAX([Data doc.faturamento p/índice de docs.faturamto.e impressão - (VBRK-FKDAT)]))>=(TODAY()-120),COUNT(distinct([Cliente emissor da Ordem de Vendas - (VBAK-KUNNR)])),'0')

 

When I have the dimension set as "Cliente" I can count the number of registries and see how many "Clientes" I have on "Ativo" or "Inativo", but I cant group them by Estate.

 

If I select State as my major dimension on a graphic the data is displayed summarizing all the registries considering just the recent date on the state and not counting the dates separatedly.

 

Can you guys help me?

 

Thanks!

 

Labels (4)
1 Reply
Channa
Valued Contributor III

Re: Error Converting a Table to Graphs

may be in your data model Estate is not related to other two dimensions

Channa