Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

RutiTaumanRubin
Contributor

Issue with BarChart - Qliksense

Hi All,

I create BarChart with 2 dimensions - Sales and Quarter and 1 measure - Amount.

I create filter in the measure so it displays the last three quarters:

count({$<PERIOD={'$(=$(vPERIOD_MAX))','$(=$(vPERIOD_MAX2))','$(=$(vPERIOD_MAX1))'}>}Sales)

The graph display the last 3 quarter but in the legend it display everything and doesn't filter the last 3 quarter...

Could you please advise?

Thank you,

Ruti.

5 Replies

Re: Issue with BarChart - Qliksense

that is strange, may be if you can share a sample it might help to see what might be going wrong? Or not sure, but if omarbensalem‌ have any ideas here

OmarBenSalem
Esteemed Contributor

Re: Issue with BarChart - Qliksense

Yes, Qlik won't adapt the quarters in the legends..

I'll suggest u to change ur dimension from

Quarter to:

if(PERIOD='$(=$(vPERIOD_MAX))' or PERIOD='$(=$(vPERIOD_MAX1))' or PERIOD='$(=$(vPERIOD_MAX)2)',Quarter)


Example: per analogy :

even though my expression is sum({<Dim2={'a','b','c'}>}Expression1)

all the Dim2 values are shown in th chart

Capture.PNG


But if I change the dimension from Dim2 to :

=if(Dim2='a' or Dim2='b' or Dim2='c',Dim2)


The result would become:

Capture.PNG

Re: Issue with BarChart - Qliksense

This is strange, seems like a bug, right?

OmarBenSalem
Esteemed Contributor

Re: Issue with BarChart - Qliksense

Yes.. seems to me.. mto‌; can u look at this please?

RutiTaumanRubin
Contributor

Re: Issue with BarChart - Qliksense

Thank you for your response ..

I remember that It's worked in the past like I developed...

Community Browser