(' Q ' )dimension in Single Quotation at script. why?

[psankepalli]

Everyone,

I was wondering, why do we mention dimension in dimensions in ' ' (Single Quotation)? what is the reason for that?

Example:

'Q' & Ceil (rowno()/3) as Quarter 

Thanks

Prasanna

[Anonymous]

To Represent Quarter, we use this notation: This 'Q' will get append to your Ceil() return Value.....

Why do we mention? Very simple answer: To make it user readable & more friendly so that any one who is accessing the QV dashboard will understand that this is Quarter

[psankepalli]

Thank you for your reply. I was looking for any other logic behind that?

[johnw]

Not sure what kind of logic you're looking for other than readability? Or are you asking about more than the 'Q', and more about quarters in general? I'm typically not trying to compare, say, Q1 in two different years, but rather see a quarterly trend that may extend across years. So I don't find "Q1" very useful, and prefer "Q1 2016". But that doesn't sort by the text, and I prefer anything date-like to be an actual date anyway. So I use this:

,dual('Q' & ceil(month([Date])/3) & ' ' & year([Date]),quarterstart([Date])) as [Quarter]

In your script, apparently each row is a month, and so rowno() is probably equivalent to my month([Date]).

[hic · Accepted solution]

... and if your question rather concerns why single quotes are used, then the answer is that single quotes are used for strings and double quotes are used for field references. See more on QlikView Quoteology

HIC