topic Data Modelling in QlikView

Data Modelling

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

Hi Folks,

I got struck on a requirement in the modelling part.

Tab1

Tab2

Tab3

abc

def

ghi

jkl

mno

I'm having three tables which is linked properly. (here i have not mentioned the key).

When i click on the value 'A' in Tab1, the possible values in Tab2 is '2' and in Tab3 is 'ghi'.

I need to restrict the value 'A' from Tab1 and the possible values to it.(The value 'A' need to hide)

The values '2' and 'ghi' from tab2 and tab3 may be a possible values to another values in the tab1.

I need to restrict only for 'A' from tab1 .

Please suggest me some logic to restrict the data.

Regards

Krishna

Re: Data Modelling

ramasaisaksoft — Tue, 29 Mar 2016 06:24:22 GMT

Hi Krishna,

Case1 :just call except 'A' column from Table1

Case2: Change all values in column 'A' is '0'

Re: Data Modelling

avinashelite — Tue, 29 Mar 2016 06:24:56 GMT

you need to restrict the values in the load script or the front end ??

Re: Data Modelling

krishna20 — Tue, 29 Mar 2016 06:26:12 GMT

I need to restrict the values in the load script Avinash.

Re: Data Modelling

MayilVahanan — Tue, 29 Mar 2016 06:27:32 GMT

Are you want to remove 'A' from tab1?

Load * from table1 where Tab1 <> 'A';

Re: Data Modelling

amayuresh — Tue, 29 Mar 2016 06:29:09 GMT

Option 1: Ignore A values in Tab 1 during loading.

Option 2: put condition to avoid A values at UI level

Re: Data Modelling

tyagishaila — Tue, 29 Mar 2016 06:33:00 GMT

=if( not wildmatch(Dimension, 'A' ), Dimension)

Here Dimension is whatever dimension for 'A' in Tab1

Re: Data Modelling

krishna20 — Tue, 29 Mar 2016 06:34:00 GMT

Hi Mayil,

I restrict the value A, from tab1, by using where condition Tab1<>'A'.

but the possible values still showing in Tab2 and Tab3 .

Re: Data Modelling

tyagishaila — Tue, 29 Mar 2016 06:42:24 GMT

Do you want to hide A?

you want to restrict possible value of A...

to understand/resolve issue share qvw file.

Re: Data Modelling

MayilVahanan — Tue, 29 Mar 2016 06:42:47 GMT

Do you want to remove those values also? If so, you exists function..

Load * from table1 where Tab1 <> 'A';

Load * from table2 where exists(KeyFieldFromtable1, KeyFieldFromTable2);

Use Keep function

Load * from table1 where Tab1 <> 'A';

Left Keep

Load * from table2;

It load the data only based on table 1...

Hope it helps

Re: Data Modelling

tyagishaila — Tue, 29 Mar 2016 06:44:42 GMT

these values are showing because

as you said,

The values '2' and 'ghi' from tab2 and tab3 may be a possible values to another values in the tab1.

Re: Data Modelling

engishfaque — Tue, 29 Mar 2016 06:48:26 GMT

Dear Krishna20,

Here is script,

Table:

Load

From YourTableName

Where Tab1 <> 'A';

Kind regards,

Ishfaque Ahmed

Re: Data Modelling

krishna20 — Tue, 29 Mar 2016 06:51:09 GMT

Hi sorry,

I can't upload a sample file. Uploading data is restricted. Give me some time i will try to explain with images

Re: Data Modelling

avinashelite — Tue, 29 Mar 2016 06:54:28 GMT

could you try with the Exists() function keyword , share the Key column so that we can base the solution out of it