Solved: Re: how to display quaters expression value in ba... - Qlik Community

kunkumnaveen · ‎2016-03-07

Hello All,

i am trying to convert my straight table into bar chart,the problem is......i cant able to display quarters expression value...how to display then as well?.....

dimension:LOCATION

expression1:current score

exp2(current quarter) :FirstSortedValue(QUARTER,-ADATE)

exp3: previous score

exp4(previous quarter):FirstSortedValue(QUARTER,-ADATE,2)

exp2 and exp4 are missing

please fins the attachment .......

kaushiknsolanki · ‎2016-03-07

Opps Sorry Wrong paste..

Here is the what you are looking.

Use this as label for expression.

='Current Audit Score (' & Aggr(FirstSortedValue(QUARTER,-ADATE), LOCATION) &')'

='Previous Audit Score(' & Aggr(FirstSortedValue(QUARTER,-ADATE,2), LOCATION) &')'

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!

View solution in original post

kaushiknsolanki · ‎2016-03-07

Hi,

Both Expressions are not shown because they are text.

Because the Current Quarter and Previous quarter will remain same for all locations, you can just display them on chart using the "Show Title in Chart" option under General Tab.

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!

kunkumnaveen · ‎2016-03-07

Hello,

what exactly do i need to do..?

as u said i tried by writing this expression in "Show Title in Chart".... ....

FirstSortedValue(QUARTER,-ADATE)

but no change ....that what u mean

kaushiknsolanki · ‎2016-03-07

Hi,

You wont get the Quarter values in Bar, instead I am saying you to show the Quarters as text, instead of Bar.

The function which you used should have gave you current quarter.

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!

kunkumnaveen · ‎2016-03-07

HI,

Sorry for annoying you ......so u mean i should use text box to display those dynamic quarters...but in case if each location quarter varies then?...currently i am using sample data

kaushiknsolanki · ‎2016-03-07

Hi,

Can you paste sample Data, I will show you what you can do.

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!

sunny_talwar · ‎2016-03-07

How exactly do you imagine to see this Quarter data on a bar chart?

kunkumnaveen · ‎2016-03-07

Hello sunny,

to be honest with you i actually dont know how to display them..but only the thing is as it is crystal clear when ur looking at the straight table will it be possible that clear by using bar chart ...what i mean like in straight table

current score and current quarter and previous score and previous quarter ........so the user should see score and its respective quarter

kunkumnaveen · ‎2016-03-07

HI ..

as the data is in remote area its not letting me to copy

please find the attachment (data slide)

sunny_talwar · ‎2016-03-07

Does current score corresponds to current quarter and previous score corresponds to previous quarter? If it does, then may be text on axis can be used where you can show that current score belongs to current quarter underneath the bar?

how to display quaters expression value in bar chart