topic Re: Issue in dimension in QlikView

Issue in dimension

ferha_jafri — Fri, 31 Jan 2014 16:14:56 GMT

Hello Everyone,

I am attaching a sample data for my issue , my issue is that i want to show those dimension for which the value of expression is greater than 0.

Thanks in advance

Ferha Jafri

Re: Issue in dimension

Anonymous — Fri, 31 Jan 2014 16:25:50 GMT

Ferha

In your sample the expression is always greater than zero for every permutation of selections.

Is there something I a missing ?

Re: Issue in dimension

ferha_jafri — Sat, 01 Feb 2014 05:03:27 GMT

In this i wrote 2 expression one for rows > 0 and other is the row total as user wants the weighted sum to be taken in the total not rows total , so i want to include 2 states for row >0 and all states for total ,so i m using this expression now i am the correct summation in total and row wise but the states which i don't want in from of them i am getting 0 although i don't want to show them.

Re: Issue in dimension

sudeepkm — Sat, 01 Feb 2014 05:34:27 GMT

I've created an example using your data and showing Quantity by States.

One chart shows all States and another chart shows only those States where the Quantity is > 400.

You can change it as per your requirement.

Re: Issue in dimension

Sat, 01 Feb 2014 17:20:05 GMT

Hello Dear

Find Attachment for Solved Qvw file.

Regards

Asim

Re: Issue in dimension

ferha_jafri — Sun, 02 Feb 2014 06:55:10 GMT

Hi Sudeep ,

The above expression is working fine for simple expression ,please check my expression , it is a bit complicated ,i am attaching the application again .Let me explain the expression to you what is happening in the expression is :

i am calculating as per the formula as 1-fabs(abs-forecast)/forecast this is am calculating row wise and in the total i am calculating the weighted of these values and total is independent of Brand desc.Please check.