topic Re: small req in QlikView

small req

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I have table like this

load * inline [

country,currency,amount

ind,inr,1.5

ind,usd,2.5

ind,,aud,3.5

];

I want to do this only ui chart level straight table,

my dimensuion is country and expression is sum(amount) so charts shows

ind 7.5 which I don't like to see aggregate the value

I want see in chart it self

ind 1.5

ind 2.5

ind 3.5

but if I add currency as other dimension then I am able to see the result (where I don't want add and hide the dim3endion)

how to achieve this

Re: small req

kaushiknsolanki — Thu, 13 Jul 2017 06:51:05 GMT

Hi,

Use the Tablebox object instead of Chart object.

Regards,

Kaushik Solanki

Re: small req

Anil_Babu_Samineni — Thu, 13 Jul 2017 06:56:30 GMT

May be use straight table with Dimension as country and currency

Expression is Sum(amount)

And hide the dimension from presentation tab.

Re: small req

avinashelite — Thu, 13 Jul 2017 07:04:25 GMT

Try like this

sum(TOTAL<currency> amount)

Re: small req

Anonymous — Thu, 13 Jul 2017 07:56:47 GMT

Hi Anil,

As I mentioned above I don't want to use dimension currency and hide it in chart ,

I want achieve with only country as dimension and sum(amount) as expression

Re: small req

Anonymous — Thu, 13 Jul 2017 07:58:20 GMT

As I Mentioned above I have to do this only straight table

Re: small req

Anonymous — Thu, 13 Jul 2017 08:04:50 GMT

Tried all the ways but no luck

Re: small req

tresB — Thu, 13 Jul 2017 08:12:21 GMT

Is using a calculated dimension an option or even making changes in the script (may be adding a field)?

Re: small req

Anil_Babu_Samineni — Thu, 13 Jul 2017 08:15:59 GMT

Okay

Re: small req

Anonymous — Thu, 13 Jul 2017 08:17:51 GMT

only in ui level I want do that ,

its direct dimension

Re: small req

tresB — Thu, 13 Jul 2017 08:21:01 GMT

May I know the business requirement that makes you put so many constraints? Or, this is just a possibility check?

Re: small req

effinty2112 — Thu, 13 Jul 2017 08:32:43 GMT

Hi,

You could use a straight table with dims country and amount. No expression - suppress zero values in Presentation tab. This will in effect turn your straight table into a tablebox.

cheers

Andrew

Re: small req

Anonymous — Thu, 13 Jul 2017 08:51:21 GMT

Pls look at attached link

Re: small req

Anonymous — Thu, 13 Jul 2017 08:51:55 GMT

I have attached requirement in app

pls find attached qvw on thread

Re: small req

Anonymous — Thu, 13 Jul 2017 08:52:11 GMT

attached the qvw pls have a look anil

Re: small req

kaushiknsolanki — Thu, 13 Jul 2017 09:44:07 GMT

Hi,

You should use the sum(EADoriginalcurrency*currencyrate)

Because what you are looking for is the weighted sum.

Try it and let us know.

Regards,

Kaushik Solanki

Re: small req

Anonymous — Thu, 13 Jul 2017 10:06:35 GMT

I cant do that reason is

sum({<PERIOD={201703}>}EADoriginalcurrency) * SUM({<PERIOD={201702}>}currencyrate)

EAD ORIGINALAMOUNT WILL BE taken for prd month , currency rate will be for compariusiion month