topic Re: how to make an expression in QlikView

how to make an expression

Sun, 18 Sep 2016 02:30:14 GMT

Hi,

Everyone,I have a problem about making a chart like below,

Comments:

Levels:A、B、C (with the sales data)

So, how to write the expression with a chart in the Sample?

Best Regards!

Re: how to make an expression

Anil_Babu_Samineni — Sun, 18 Sep 2016 03:45:23 GMT

From Your Example, What are you expecting?

Re: how to make an expression

Sun, 18 Sep 2016 03:52:08 GMT

thanks for your reply , perhanps it's a dynamic dimension case. It will help a lot if you make it out.

Re: how to make an expression

Digvijay_Singh — Sun, 18 Sep 2016 04:41:57 GMT

The representation is bit confusing, can you try mapping all of your example values in your representation.

For example, ID001, Year 2014, Sales=4, you didn't show it in pic. If you can map your 6 example values in expected output, I think I can make equivalent in pivot table.

Re: how to make an expression

trdandamudi — Sun, 18 Sep 2016 05:17:11 GMT

Your sales numbers are not tagged in the source data. But I just assumed and mapped it to you source data. So take a look and see if this helps:

Re: how to make an expression

Sun, 18 Sep 2016 05:25:23 GMT

thanks for reply, I 'm sorry for confusing you, please see the question above, I have modified it.

Re: how to make an expression

Sun, 18 Sep 2016 05:28:14 GMT

thanks for your reply, the field "Level" in your reply is not suspected to exist, for it's dynamic with other fields selecting

Re: how to make an expression

Digvijay_Singh — Sun, 18 Sep 2016 05:33:03 GMT

May be I am missing something but all I am asking is you have 3 values for 2014 and 3 values for 2015. Since you are showing 2014 and 2015 values separately, vertical(2015 values as rows) and horizontal(2014 values as columns), all I want to see 6 values in expected output.

Re: how to make an expression

Digvijay_Singh — Sun, 18 Sep 2016 05:34:11 GMT

all values must falls into one of the 3 conditions so we should see 6 1's corresponding to 6 values.

Re: how to make an expression

trdandamudi — Sun, 18 Sep 2016 06:25:08 GMT

I made the change to reflect the 'Level' in the code:

Load *,

IF(Sales<=5,'A',If(Sales >5 and Sales <=10,'B',If(Sales >10,'C'))) as Level;

LOAD * INLINE [

ID, Year, Sales

ID001, 2014,4

ID002, 2014,8

ID003, 2014,12

ID001, 2015,7

ID002, 2015,11

ID003, 2015,4

];

QUALIFY *;

UNQUALIFY ID;

t1:

LOAD *

Resident t;

Re: how to make an expression

Sun, 18 Sep 2016 06:28:21 GMT

thanks a lot , but the Level is dynamic, so it does not calculate in the code ,but in the expression.

Re: how to make an expression

Sun, 18 Sep 2016 10:11:41 GMT

so, I worked it out. Thanks for all your help.