topic Re: How to take correct dimension in QlikView

How to take correct dimension

Thu, 17 Oct 2013 10:20:59 GMT

Hi,

I have to create a chart which shows Salary to Date. so, in this case do I need to take dimension as Today().

can anyone let me kno please.

Thanks.

Re: How to take correct dimension

Thu, 17 Oct 2013 10:25:14 GMT

No, probably employee id or name.

Re: How to take correct dimension

swuehl — Thu, 17 Oct 2013 10:26:05 GMT

If you just want to show 1 data point, you don't need to use a dimension in a (bar / table) chart, just create your expression that calculates the result, or use e.g. a gauge chart or text box to show that value.

Re: How to take correct dimension

vikasmahajan — Thu, 17 Oct 2013 10:28:01 GMT

Actually IT is depend upon your data model how it is designed if employee id is linked I think as per Thomas

Employee ID , Location ID, Cost Center,Dept Id can be a dimensions.

Vikas

Re: How to take correct dimension

Thu, 17 Oct 2013 10:32:45 GMT

Thanks yes I need guage chart and I have to show TotalAmount, Commission and origianlsalaryon data points.

so can you help me how to create guage chart as when I am trying it is showing just blank guage without any readings.

Re: How to take correct dimension

Thu, 17 Oct 2013 10:42:25 GMT

Thanks and yes Employee ID is linled and when I am using Emloyee ID it is showing one big line at 0% . can you please help me in this.

Re: How to take correct dimension

Thu, 17 Oct 2013 11:37:44 GMT

Hi, when I am using employee id it is showing only one big line at 0. can you let me know please how to sort this.