topic Re: Expression / Formula Help! in QlikView

Expression / Formula Help!

Fri, 20 Dec 2013 15:03:15 GMT

I've loaded data into QV using cross table (in case this makes a difference) I have year as a dimension and have a poivot table showing both years side by side.

The expression for the data is sum(Data) but I wanted to show a growth% for the different products as per below. As Year is one dimension I'm stuck as how to do this?

Products	Year	2012	2013	Growth %
Product a		100	110
Product b		100	105

Can anyone help?

Re: Expression / Formula Help!

rustyfishbones — Fri, 20 Dec 2013 15:07:09 GMT

can you share the app

Re: Expression / Formula Help!

Fri, 20 Dec 2013 16:42:23 GMT

How do I add the file?

Re: Expression / Formula Help!

Peter_Cammaert — Fri, 20 Dec 2013 16:47:06 GMT

Add a reply but edit the text in the advanced editor. Below the editing frame on the right, there is a link to Add an attachment to your message.

Best,

Peter

Re: Re: Expression / Formula Help!

Anonymous — Fri, 20 Dec 2013 16:47:36 GMT

Hasnain

When replying, make sure you are in the Advanced Editor by clicking use advanced editor, top right of Reply Box.

Then click Attach in bottom right

Best Regards, Bill

Re: Expression / Formula Help!

Anonymous — Fri, 20 Dec 2013 18:23:47 GMT

Something like this:

if(SecondaryDimensionality()>0,

money(sum(Data)),

num((sum({<Year={2013}>} Data)-sum({<Year={2012}>} Data))/sum({<Year={2012}>} Data),'###.#0%')

)

In Number tab, use Expression Defaul.

Re: Re: Expression / Formula Help!

Mon, 23 Dec 2013 16:03:06 GMT

Thanks all. I've created a simplififed application to illustrate the issue, see attached both the application and the spreadsheet I've used to load data into it (via cross table hence the issue). Any help would be much appreciated.

Thanks

Hasnain

Re: Re: Re: Expression / Formula Help!

Gysbert_Wassenaar — Mon, 23 Dec 2013 16:50:03 GMT

See attached qvw. Your sample had data for only one year so I used month instead. The principle is the same though.