Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

nevilledhamsiri
Valued Contributor

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
Honored Contributor III

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

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))

));

10 Replies
nevilledhamsiri
Valued Contributor

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

Please refer attachment for requested issues

Thanks

Neville

nevilledhamsiri
Valued Contributor

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

Could you please look n to this?

Regrds

Neville

Digvijay_Singh
Honored Contributor III

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

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
Honored Contributor III

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

Better expression for list box may be this one -

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

nevilledhamsiri
Valued Contributor

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

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
Honored Contributor III

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

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
Valued Contributor

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

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
Valued Contributor

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

Something like below!

Digvijay_Singh
Honored Contributor III

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

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.

Community Browser