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: 
nevilledhamsiri
Specialist
Specialist

Restrict data through list box, let load with '0000, blank rows to be renamed as '0000

Hi,

I have following issues which are required to be learnt from you!

Number_1

Dimension with business code loaded '0000  as just 0. I need full 0000 to be loaded on the P/T

Number_2

Dimension with business code carries two blank rows, i need this two rows to be copied with '0000

Number_3

List box on Class code to be restricted  with  CH & EN codes  being excluded from showing. How this is achieved with above two cases

Regds

Neville

1 Solution

Accepted Solutions
Digvijay_Singh

May be this -

Capture.PNG

LOAD BRANCH_CODE,

     CLASS,

     Text(BUSINESS_CODE) as BUSINESS_CODE,

     CF_TOTAL

FROM

[..\..\..\..\..\..\Downloads\RESTRICTED_BOX.xlsx]

(ooxml, embedded labels, table is Sheet1, filters(

Replace(3, bottom, StrCnd(null))

));

View solution in original post

10 Replies
nevilledhamsiri
Specialist
Specialist
Author

Please refer attachment for requested issues

Thanks

Neville

nevilledhamsiri
Specialist
Specialist
Author

Could you please look n to this?

Regrds

Neville

Digvijay_Singh

May be this -

Capture.PNG

LOAD BRANCH_CODE,

     CLASS,

     Text(BUSINESS_CODE) as BUSINESS_CODE,

     CF_TOTAL

FROM

[..\..\..\..\..\..\Downloads\RESTRICTED_BOX.xlsx]

(ooxml, embedded labels, table is Sheet1, filters(

Replace(3, bottom, StrCnd(null))

));

Digvijay_Singh

Better expression for list box may be this one -

=if(not WildMatch(CLASS,'CH','EN'),CLASS)

nevilledhamsiri
Specialist
Specialist
Author

Thanks Digvijay,

Your solutions are absolutely fine! One more clarification please.

As you suggested in restricting some class such as 'CH', 'EN', if I am to restrict the same in the pivot table both class (EN & CH) together with their respective CF_TOTAL,what could be the set expression to be used?

Thanks

Neville

Digvijay_Singh

I think same expression works for pivot as well or this as well -

Please close the thread by marking correct/helpful answers if it helps or post further questions.

Capture.PNG

nevilledhamsiri
Specialist
Specialist
Author

Should this expression to be applied on the class dimension as a calculated dimension?. If it is so only that classes are not shown but cf total being reflected against a null value

Thanks

nevilledhamsiri
Specialist
Specialist
Author

Something like below!

Digvijay_Singh

I think you should not use CF_TOTAL as dimension? It should be a measure? Please let me know in case I am missing some requirement.