topic Re: Var and Diff in QlikView

Var and Diff

sannidhikumar — Tue, 24 Jan 2017 12:52:43 GMT

hi ALL ,

when i am selecting in variance Y and Difference N its not selecting properly .

any suggestions ,

please follow screen shot

thanks ,

Re: Var and Diff

sannidhikumar — Wed, 01 Feb 2017 05:44:25 GMT

hi ALL,

can any one can answer to my question .

any suggestions let me know .

thanks ,

Re: Var and Diff

rulohx87 — Wed, 01 Feb 2017 21:00:58 GMT

Can you share what result you expect? And more behavioral information than the selections should have.

Re: Var and Diff

sannidhikumar — Fri, 03 Feb 2017 08:49:41 GMT

hi Raut ,

according to two expressions the variance value we getting when we click on 'yes' then it should display the values only that is expected result .

thanks

Re: Var and Diff

sannidhikumar — Fri, 03 Feb 2017 08:53:29 GMT

Re: Var and Diff

rahulpawarb — Fri, 03 Feb 2017 09:00:01 GMT

Does this means table should display variance & differences fields based on selection made else it should be in hidden state? If you share application with sample data then it will help us to provide your expected results.

Re: Var and Diff

sannidhikumar — Fri, 03 Feb 2017 09:29:37 GMT

this is what from app rahul so i not allow to do but took screen shot for your information .

actually result should be when i click on yes only variance values should display with out zeros that is expected .

any suggestions ,

thanks ,

Re: Var and Diff

rahulpawarb — Sun, 05 Feb 2017 04:35:01 GMT

Hello Pradeep,

As per my understanding, you can create a resident table which will populate variance & difference check parameters shown as below:

Check:

LOAD Id,

Product AS PName,

If(Sum(Variance)>0,'Y') AS IsVariance,

If(Sum(Difference)>0,'Y') AS IsDifference

Resident TestData

Group by Id, Product;

Refer attached application for your reference.

Hope this will help.

Regards!

Rahul

Re: Var and Diff

sannidhikumar — Mon, 06 Feb 2017 13:09:03 GMT

Rahul ,

its not working my expectation result should be not to get zeros when it is selected yes in variance expression side but still it displaying zero. .

any other suggestions ,

thanks ,

Re: Var and Diff

rahulpawarb — Tue, 07 Feb 2017 05:26:37 GMT

Hello Pradeep,

Could you please share the application with Sample data? This will help us to further drill down.

Regards!

Rahul