topic Re: How to show the Difference in QlikView

How to show the Difference

Mon, 15 Feb 2016 08:19:49 GMT

Hi friends,

I wanna show the diff b/w two values dynamically. I've 4 expression and one more expression for Difference using in Ad-hoc concept.

when I select any two exp from that 4 it show the Diff b/w that 2 exp in the same table. based on current selection only it should show

For Example

if I've Exp like below,

%Expression

Total Sales-14, //(Sum TSales-14)

Total Sales-15, //(Sum TSales-15)

Sales-14, //(Sum Sales-14)

Sales-15, //(Sum Sales-15)

Diff //(???????????????)

for Diff I don't know what kind of exp I 've to try..

User can select any 2 dimension to know the Diff. So I need that exp as Dynamically (Based on User current Selected Expressions)

Thanks

in advance

Abinesh S

Re: How to show the Difference

Anonymous — Mon, 15 Feb 2016 08:22:59 GMT

Try like this?

=(Sum TSales-14) - (Sum TSales-15) as per your requirement

Re: How to show the Difference

Mon, 15 Feb 2016 08:28:21 GMT

Thanks for you reply Balraj,

I need that exp dynamically.... In your exp it show only Diff b/w 14 &15 Total sales only but In user point of view they will select any exp like "TSale-14 - Sale-15" or "Sale-14 -TSale-15" So I need that Diff exp completely based on user selection only...

Re: How to show the Difference

Anonymous — Mon, 15 Feb 2016 08:35:10 GMT

like this?

Dynamically Change Expressions

Re: How to show the Difference

PrashantSangle — Mon, 15 Feb 2016 08:38:34 GMT

Hi,

Adhoc Reporting will help you to achieve above concept.

You need to customize that concept according to your requirement.

For how to create Adhoc report navigate below link

Adhoc reporting in Qlikview‌

Regards,

Re: How to show the Difference

sfatoux72 — Mon, 15 Feb 2016 08:43:09 GMT

If your 2 expressions are dynamically selected, you could write your difference like that:

= Column(2) - Column(1)

Re: How to show the Difference

Mon, 15 Feb 2016 08:53:24 GMT

Thanks Sebastien its work properly.. Thank you very much. And one more doubt when I select the exp in adhoc it sort the exp by values but I wanna sort the exp by user selection wise.

For eg:

Sales=1000

Target=1100

User select the Target 1st and the select sales 2nd and check the diff in that time in qlik view it show "-100" based on values it sorting itself.... guys help on this also

Re: How to show the Difference

Mon, 15 Feb 2016 08:56:58 GMT

Guys thanks to all of you I got the solution for my 2nd query also...

Re: How to show the Difference

sfatoux72 — Mon, 15 Feb 2016 09:02:40 GMT

New question --> new thread

It will more helpfull for other users.

You could refer to this thread and add a sample of your application, it will be more simple to understand what you did and how to help you.

Re: How to show the Difference

Anonymous — Mon, 15 Feb 2016 09:51:41 GMT

The expressions are taken in the list box and take the text box write the expression getselectioncount(field)- ( getselectioncount(field)-1)