topic Re: (' Q ' )dimension in Single Quotation at script. why? in QlikView

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

psankepalli — Thu, 25 Feb 2016 13:12:24 GMT

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

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

Anonymous — Thu, 25 Feb 2016 13:17:55 GMT

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

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

psankepalli — Thu, 25 Feb 2016 20:47:12 GMT

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

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

johnw — Thu, 25 Feb 2016 21:04:42 GMT

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]).

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

hic — Thu, 25 Feb 2016 21:17:54 GMT

... 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