Year, month, week format?

[Anonymous]

Hi,

is it possible to produce the following format in QlikView?

I have tried several things without luck.  Any help appreciated

[Anonymous]

yeh but I cant see where to do it?

[sunny_talwar]

I am not sure I understand the requirement very well. Would you be able to modify the last qvw and create a sample to look at the issue?

[Anonymous]

Hi Sunny,

can you see where I am going wrong? I want to say if field State is not ‘NSW','VIC','QLD','WA','AC','NT','TAS' or 'SA' then make it ‘Other’

=if(State-={‘NSW','VIC','QLD','WA','AC','NT','TAS','SA'},'Other',State)

Regards,

Laura Castagna

Business Systems and Process Analyst, NSW Business Chamber

140 Arthur Street North Sydney NSW 2060

Tel: 02 9458 7804 | Mob: 0429 486 934 | Web: www.nswbusinesschamber.com.au<http://www.nswbusinesschamber.com.au>

Twitter<http://www.twitter.com/nswbc> | Facebook<https://www.facebook.com/NSWBusinessChamber> | LinkedIn<http://www.linkedin.com/company/388425?trk=saber_s000001e_1000> | YouTube<http://www.youtube.com/nswbctv>

<http://www.nswbusinesschamber.com.au/>

[sunny_talwar]

This is not within set analysis right? Try this:

If(not Match(State , ‘NSW', 'VIC', 'QLD', 'WA', 'AC', 'NT', 'TAS', 'SA'),'Other', State)