topic Re: Bar chart in QlikView

Bar chart

deepakqlikview_123 — Fri, 29 May 2015 15:37:30 GMT

Hi All,

Please find sample qvw and attached screenshot.

I need to show names on bar chart as shown in attachment.

Can you please suggest which string function shall i use to get bar names as shown in screenshot.

thanks

Re: Bar chart

sunny_talwar — Fri, 29 May 2015 15:46:06 GMT

Are you referring with regards to the sorting?

Re: Bar chart

sunny_talwar — Fri, 29 May 2015 15:49:01 GMT

Is this the goal?

If yes then you can sort your dimension by expression in descending order with this expression (which is the same expression as your bar chart expression):

=(Avg({<INDICATOR_NAME={'Real Estate EPS % change','Financials (Sector) EPS % change','Utilities EPS % change','Technology EPS % change','Material EPS % change'

,'S&P 500 Consumer Discretionary Sector Index = Discretionary EPS % change','Telecom EPS % change','Health care EPS % change','S&P 500 EPS % change',

'Industrials EPS % change','S&P 500 Consumer Staples Sector Index = Staples EPS % change','Energy EPS % change'}>}INDICATOR_VALUE))/100

I hope this helps.

Best,

Sunny

Re: Bar chart

deepakqlikview_123 — Fri, 29 May 2015 16:06:17 GMT

Hi,

I wanted to know which calculated dimension shall i use in my application to get the names as shown in screenshot

thanks

Re: Bar chart

sunny_talwar — Fri, 29 May 2015 16:18:48 GMT

Use this as your calculated dimension:

=Replace(Subfield(INDICATOR_NAME,' ',1) & ' ' & Subfield(INDICATOR_NAME,' ',2), ' EPS', '')

Output:

Re: Bar chart

deepakqlikview_123 — Fri, 29 May 2015 17:37:08 GMT

Thanks sunindia but I want to show Financials(sector) as only Financials also

Re: Bar chart

sunny_talwar — Fri, 29 May 2015 17:41:21 GMT

This may be:

=Replace(Replace(Subfield(INDICATOR_NAME,' ',1) & ' ' & Subfield(INDICATOR_NAME,' ',2), ' EPS', ''), '(Sector)', '')

Another simpler solution would be to do this in the script using a mapping load.

HTH

Best,

Sunny

Re: Bar chart

deepakqlikview_123 — Fri, 29 May 2015 17:45:10 GMT

Thanks Suninda for your promp reply.

Can you please suggest how mapping load would work in this case

Re: Bar chart

sunny_talwar — Fri, 29 May 2015 17:54:22 GMT

I added this to your script:

Table:

Add LOAD * Inline [ \\ I used add because I needed to do a partial reload, in your case you won't need Add here

INDICATOR_NAME, NEW_INDICATOR_NAME

Real Estate EPS % change, Real Estate

Financials (Sector) EPS % change, Financials

Utilities EPS % change, Utilities

Technology EPS % change, Technology

Material EPS % change, Material

S&P 500 Consumer Discretionary Sector Index = Discretionary EPS % change, S&P 500

Telecom EPS % change, Telecom

Health care EPS % change, Healthcare

S&P 500 EPS % change, S&P 500

Industrials EPS % change, Industrials

S&P 500 Consumer Staples Sector Index = Staples EPS % change, S&P 500

Energy EPS % change, Energy

];

Now I can use NEW_INDICATOR_NAME instead of the old one. This was a regular reload, but you can always use a Mapping Load with Apply Map or you can join the above table to your existing fact table.

I hope this helps.

Best,

Sunny

Re: Bar chart

deepakqlikview_123 — Fri, 29 May 2015 18:00:14 GMT

Thanks Sunindia

Re: Bar chart

sunny_talwar — Fri, 29 May 2015 18:02:26 GMT

‌no problem....

Re: Bar chart

deepakqlikview_123 — Tue, 14 Jul 2015 07:15:40 GMT

can you please suggest how to show this ascending order

Re: Bar chart

sunny_talwar — Tue, 14 Jul 2015 10:12:17 GMT

See it like this?

Use this sorting:

HTH

Best,

Sunny

Re: Bar chart

deepakqlikview_123 — Tue, 14 Jul 2015 10:20:10 GMT

as we are using indicator value as per max of date this is not working fine

Re: Bar chart

sunny_talwar — Tue, 14 Jul 2015 10:25:11 GMT

Not sure what you mean? Are we still doing this in the above qvw and chart? or is it some new qvw or chart you are talking about?