topic Re: Straight Table in QlikView

Straight Table

Wed, 08 Aug 2012 06:39:12 GMT

I have a data which has following fields...

Date Day ,Exchange Rate

Now in a straight table i want to show Max Exchange rate ,Day of Max Exchange Rate across CalendarWeeknumber

For Example

6 41 Thursday

7 40 Monday

8 42 Tuesday

Wed, 08 Aug 2012 06:54:40 GMT

Hi,

can't you use Week(Date) as week_num to get the exact week

then use this week_num field and all other existing fields as dimensional fields with max(Exchange rate) as expression

Wed, 08 Aug 2012 07:07:03 GMT

thanks for the reply but i want the day on which exchange rate is max for every week??

Suppose in 5th week of the year thursday is the day when exchange rate is max... similarly for other weeks

Wed, 08 Aug 2012 07:19:22 GMT

Hi,

WeekDay(Date) will returns the day name say thursday..,

hope this helps

Wed, 08 Aug 2012 07:42:54 GMT

use dynamic dimension week(date) and as expression you use weekday({<ExchangeRate = {'$(=max(ExchangeRate))'}>}date)

you might don't need the '' in set analysis just try it out