topic Re: selection and dimension in QlikView

selection and dimension

Anonymous — Mon, 07 Jan 2013 07:00:12 GMT

Hello,

I am new to qlikview ,while reading the documentaion on set analysis I am confused what is the difference between a selection and dimension

in the below context:

sum({1} Sales)

Returns total sales within the application, "disregarding selections but not

the dimension."

Thanks for patience.

Re: selection and dimension

Mon, 07 Jan 2013 07:05:04 GMT

actually dimension means, on which basis you perfor the calculation.

and selection means on the selection do this work.

example

If I've understood what you want, you do it like this:

sum(total Sales)

The "total" keyword tells QlikView to disregard all dimension values. If you need to include some but not all of the dimensions, you list the dimensions you want to include:

sum(total <Year, Customer> Sales)

Re: selection and dimension

er_mohit — Mon, 07 Jan 2013 07:12:58 GMT

in set analysis 1 means selection based on all

and you shuld try $ sign instead of 1..

then your answer must be based on selection

hope it helps

Re: selection and dimension

Mon, 07 Jan 2013 07:14:45 GMT

Hi,

We have expression and dimension in chart ryt?

Dimension like EmpName

EmpNO

Expression like Sum({1}Salary)

Here we have list box Called EmpName,EmpNO, So If we Select any one data from these List box data are reflected to the Chart. Because these two are dimension of the chart

And we have department listbox(Selection), So if we Select any one data from that List box data are not reflected to the chart. because this is a just selection box. if it may be a dimension of chart the Data will reflect.

I hope, it helps U...

Regards,

Kabilan K

Re: selection and dimension

er_mohit — Mon, 07 Jan 2013 07:35:45 GMT

you shuld have to mark it either correct or helpful answer so that it might be helpful for others developers...