Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for Data Integration and Data Analytics gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

FIELD CATEGORIZATION

I am having the Data set as the follwing which i have attached below,

what I need is , I want to show the name and price of bike which are not listed in TOP10,TOP20,TOP30 but present only in 'IMPORTED'

Looking forward for Solutions,

Thanks in advance,

NAVEEN.A

1 Solution

Accepted Solutions
Highlighted
Master II
Master II

Re: FIELD CATEGORIZATION

You can also try like this :

Create a calculated dimension:

if(len(trim(Flag10&Flag20&Flag30)) = 0 and Flagimported = 'Imported',NAME)

exp: sum(Price)


Br,

KC

Best Regards,
KC

View solution in original post

12 Replies
Highlighted
Champion III
Champion III

Re: FIELD CATEGORIZATION

Can you share some sample data where you have the expressions for TOP10, TOP20 and TOP30. Image does not help.

Highlighted
Master
Master

Re: FIELD CATEGORIZATION

Calculated dimension can help

if(isnull(Flag10) and isnull(Flag20) and isnull(Flag30) and Flagimported = 'Imported',NAME) as NAME

Highlighted
Champion III
Champion III

Re: FIELD CATEGORIZATION

How do you know if those Flag10, Flag20 and Flag30 are fields rather expressions? Just checking.

Highlighted
Master
Master

Re: FIELD CATEGORIZATION

Just gave an idea , if they are expressions then this will  not work

Highlighted
Partner
Partner

Re: FIELD CATEGORIZATION

Those data sets are huge...thats why I shared the image...will try to attach the sample if possibe!!

Highlighted
Master II
Master II

Re: FIELD CATEGORIZATION

You can also try like this :

Create a calculated dimension:

if(len(trim(Flag10&Flag20&Flag30)) = 0 and Flagimported = 'Imported',NAME)

exp: sum(Price)


Br,

KC

Best Regards,
KC

View solution in original post

Highlighted
Partner
Partner

Re: FIELD CATEGORIZATION

Thank you so much@Jyothish KC

It worked fine...Thaks for your suggestion.

Highlighted
Partner
Partner

Re: FIELD CATEGORIZATION

Iam having one more Issue...
The issue is i need to Show the name and Price of bikes which are lot listed in any of the categories(The bike should not be listed in TOP10, TOP20, TOP30, and imported.)

Thanks in advance.

Highlighted
Master II
Master II

Re: FIELD CATEGORIZATION

try like this then:

if(len(trim(Flag10&Flag20&Flag30&Flagimported)) =0, NAME)


Br,

KC

Best Regards,
KC