Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have one column Grades which has values like Total,Net,N1,N2,N3,Profit.
I have one more column NonGrade Which is derived from Grades and contains values N1,N2,N3 and if i select one of value (ex : N1) in NonGrade I have to display values Total,Net,N1,Profit. If i click on N2 then Total,Net,N2,Profit.
I am attaching QVW also. Could you please anybody help here?
Thanks,
Vamsi
change your script with
Tab1:
LOAD * Inline [
Grade,Value,Code
Total,100000,1
Net,70000,2
N1,30000,3
N2,20000,4
N3,10000,5
];
//Tab2:
//LOAD *, If(Grade ='N1' or Grade ='N2' or Grade ='N3',Grade) as NonGrade
//Resident Tab1;
//
//DROP Table Tab1;
Tab2:
load 'N1' as NonGrade, Grade Resident Tab1 Where not Match(Grade, 'N2', 'N3');
load 'N2' as NonGrade, Grade Resident Tab1 Where not Match(Grade, 'N1', 'N3');
load 'N3' as NonGrade, Grade Resident Tab1 Where not Match(Grade, 'N2', 'N1');