Discussion Board for collaboration related to QlikView App Development.
hi ALL ,
when i am selecting in variance Y and Difference N its not selecting properly .
any suggestions ,
please follow screen shot
thanks ,
hi ALL,
can any one can answer to my question .
any suggestions let me know .
thanks ,
Can you share what result you expect? And more behavioral information than the selections should have.
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
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.
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 ,
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
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 ,
Hello Pradeep,
Could you please share the application with Sample data? This will help us to further drill down.
Regards!
Rahul