Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
sannidhikumar
Creator
Creator

Var and Diff

hi ALL ,

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

any suggestions ,

please follow screen shot

VAR & DIFF.PNG

thanks ,

9 Replies
sannidhikumar
Creator
Creator
Author

hi ALL,

can any one can answer to my question .

any suggestions let me know .

thanks ,

rulohx87
Contributor III
Contributor III

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

sannidhikumar
Creator
Creator
Author

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

sannidhikumar
Creator
Creator
Author

image.PNG

rahulpawarb
Specialist III
Specialist III

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.

sannidhikumar
Creator
Creator
Author

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 ,

rahulpawarb
Specialist III
Specialist III

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

sannidhikumar
Creator
Creator
Author

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 ,

rahulpawarb
Specialist III
Specialist III

Hello Pradeep,

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

Regards!

Rahul