topic Re: Display name in QlikView

Display name

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

Hi all,

i have date field in the table

but i want to show the dimension like below

PFA.

day1 day2 day3

how can i get like this?

can anyone help??

Re: Display name

qlikviewwizard — Tue, 29 May 2018 09:52:35 GMT

Upload some sample data.

Re: Display name

tresB — Tue, 29 May 2018 10:01:02 GMT

Try calculated dimension like:

='Day ' & Day(Date)

Re: Display name

soniasweety — Tue, 29 May 2018 10:06:11 GMT

but it is showing by default day21 day22 day23 based on my date field

but i want fixed i tried below but its not working

=if(DateName='Mon','Day1',

if(DateName='Tue','Day2',

if(DateName='Wed','Day3',

if(DateName='Thu','Day4',

if(DateName='Fri','Day5',

if(DateName='Sat','Day6',DateName))))))

Re: Display name

tresB — Tue, 29 May 2018 10:08:01 GMT

Use weekday() like:

='Day' & Num(WeekDay(Date))

Re: Display name

soniasweety — Tue, 29 May 2018 10:17:27 GMT

thanks

but i want to exclude the sunday in the dimension and day1 to day6 i need now i am getting day0 to

tried this

='Day' &if(WeekDayName<>'Sun', Num(WeekDay(DateName)))

Re: Display name

tresB — Tue, 29 May 2018 10:21:01 GMT

Try putting the if condition first, like:

=if(WeekDayName<>'Sun', 'Day' & Num(WeekDay(DateName)))

Re: Display name

qlikviewwizard — Tue, 29 May 2018 10:27:26 GMT

='Day' &if(WeekDay(DATE)<>'Sun',Num(WeekDay(DATE))+1)

Re: Display name

MarcoWedel — Tue, 29 May 2018 20:59:11 GMT

Hi,

one solution might be:

table1:
LOAD *,
    WeekDay(Date) as WeekDay,
    'Day'&(WeekDay(Date)+1) as Day,
    Ceil(Rand()*100) as Value;
LOAD Date(YearStart(Today())+RecNo()-1) as Date
AutoGenerate DayNumberOfYear(Today());

hope this helps

regards

Marco