topic Re: FIELD CATEGORIZATION in QlikView

FIELD CATEGORIZATION

naveenashokan94 — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: FIELD CATEGORIZATION

vishsaggi — Fri, 01 Jun 2018 16:20:03 GMT

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

Re: FIELD CATEGORIZATION

shiveshsingh — Fri, 01 Jun 2018 17:17:08 GMT

Calculated dimension can help

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

Re: FIELD CATEGORIZATION

vishsaggi — Fri, 01 Jun 2018 17:46:50 GMT

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

Re: FIELD CATEGORIZATION

shiveshsingh — Fri, 01 Jun 2018 17:49:46 GMT

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

Re: FIELD CATEGORIZATION

naveenashokan94 — Mon, 04 Jun 2018 05:42:02 GMT

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

Re: FIELD CATEGORIZATION

jyothish8807 — Mon, 04 Jun 2018 06:05:39 GMT

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,

Re: FIELD CATEGORIZATION

naveenashokan94 — Mon, 04 Jun 2018 06:27:33 GMT

Thank you so much@Jyothish KC

It worked fine...Thaks for your suggestion.

Re: FIELD CATEGORIZATION

naveenashokan94 — Mon, 04 Jun 2018 06:35:01 GMT

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.

Re: FIELD CATEGORIZATION

jyothish8807 — Tue, 05 Jun 2018 05:00:47 GMT

try like this then:

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

Br,

Re: FIELD CATEGORIZATION

naveenashokan94 — Tue, 05 Jun 2018 05:17:52 GMT

Thank you so much...That was very helpful.

Thanks@Jyothish KC

Re: FIELD CATEGORIZATION

jyothish8807 — Tue, 05 Jun 2018 05:23:55 GMT

welcome

Re: FIELD CATEGORIZATION

naveenashokan94 — Tue, 05 Jun 2018 05:28:03 GMT

Could you please help me with a another issue that i have posted as "Mapping Fields"..

Thanks in advance