topic Re: Total Across a Dimension in QlikView

Total Across a Dimension

Mon, 08 Sep 2014 09:24:48 GMT

Hi All ,

I am using this expression to calculate TOTAL's But even though YEar is Selected in Dimension , The expression is showing TOTAL across all Years

sum(TOTAL{<Metric={'VHL'}>}Data)/1000)

Can you help me incorporating Year Dimension in the above formula

Thanks,

Sai

Re: Total Across a Dimension

ajaykumar1 — Mon, 08 Sep 2014 09:30:12 GMT

Try like;

sum(TOTAL{<Metric={'VHL'},year={"$(=max(year))"}>}Data)/1000)

So it might work when your selecting the year that will be the max year.

Regards,

Ajay

Re: Total Across a Dimension

jonathandienst — Mon, 08 Sep 2014 09:30:49 GMT

It sounds like the Year field is not associated with the Metric and Data fields.In other words, there is no key between the table containing Year and the tables(s) containing the other fields. Check your table structure in the viewer (File | Table Viewer)

HTH

Jonathan

Re: Total Across a Dimension

israrkhan — Mon, 08 Sep 2014 09:32:06 GMT

TRY LIKE BELOW

sum(TOTAL <YEar > {<Metric={'VHL'}>}Data)/1000

Re: Total Across a Dimension

Mon, 08 Sep 2014 09:38:50 GMT

Thanks for the response ,

But none of them is working , actually my year is coming from a Dimension Month Name

I am using a Left Function ; LEFT([Month Name],4) etc..,

How do I fit the above with Total

@jonathan dienst - All fields are in single Table

thanks,

Sai

Re: Total Across a Dimension

avinashelite — Mon, 08 Sep 2014 09:40:46 GMT

Hi Sai,

Can you please share your app.