topic Re: Help in QlikView

Help

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

Dear Team,

i Stuck a Requirement.I have data where three field.Sub_CAT_CD and MC_CD AND QTY.

And One Sub_cat_Code Contain many MC_CD.

If i make two table First Sub_cat_cd wise QTY

Second is MC_CD WISE QTY

Simple Expression Sum(QTY)

But when i select any MC_CD Then First Table Should be should Sub_CAT_CD_WISE QTY WHERE Selection MC_CD_EXIST.

For this i am sharing data.kindly help me

Re: Help

bohravanraj — Thu, 10 Aug 2017 09:24:11 GMT

It will be bydefault working same.

if u select any MC_CD then it will only be showing the Sub_CAT_CD_WISE where Selection MC_CD_EXIST.

Regards,

Vanraj Dinesh Bohra

Re: Help

techvarun — Thu, 10 Aug 2017 09:28:11 GMT

Can you elaborate more in detail?

Check if the attached helps.

Re: Help

panipat1990 — Thu, 10 Aug 2017 09:28:41 GMT

Suppose i select MC_CD 111010001.

It Show the QTY 909 it is ok

But this MC_CD Coming Under This Sub_Cat_CD (1110100) Where Sum show 7300.But 909 is coming Sub_Cat_CD_wise Table. But 7300 shuold be. How is it possible

Re: Help

panipat1990 — Thu, 10 Aug 2017 09:31:31 GMT

If i select any mc_cd then in Sub_cat_cd wise table show that where this mc_cd exit

Re: Help

panipat1990 — Thu, 10 Aug 2017 09:32:16 GMT

Suppose i select MC_CD 111010001.

It Show the QTY 909 it is ok

But this MC_CD Coming Under This Sub_Cat_CD (1110100) Where Sum show 7300.But 909 is coming Sub_Cat_CD_wise Table. But 7300 shuold be. How is it possible

Help

Re: Help

techvarun — Thu, 10 Aug 2017 09:39:18 GMT

MC_CD and Sub_Cat having one to one relationship but Sub_Cat having one to many relationship with MC_CD.

Do you want to show 7300 even if we select MC_CD 111010001 alone?

share the clear requirement with screenshots if possible.

Re: Help

panipat1990 — Thu, 10 Aug 2017 09:41:10 GMT

yes sir

Re: Help

panipat1990 — Thu, 10 Aug 2017 10:06:54 GMT

I want to show 7300 even if we select MC_CD 111010001 alone

This is ok ,Kindly help me

Re: Help

panipat1990 — Thu, 10 Aug 2017 10:22:16 GMT

Hi,

here my data not attached in qvw.

Re: Help

techvarun — Thu, 10 Aug 2017 10:28:49 GMT

Sorry, attached a wrong qvw earlier.

Re: Help

panipat1990 — Thu, 10 Aug 2017 10:33:40 GMT

If i Select any MC_CD THEN IN Sub_cat_CD Table Show Sum

Re: Help

Kushal_Chawda — Thu, 10 Aug 2017 10:37:34 GMT

try this

Data:

LOAD MC_CD,

SUB_CAT_CD,

QTY

FROM

[Data.xlsx]

(ooxml, embedded labels, table is FINAL);

Left Join

LOAD SUB_CAT_CD,

sum(QTY) as QTYNEW

Resident Data

Group by SUB_CAT_CD;

Create straight table

Dimension:

MC_CD

Expression:

sum(QTYNEW)

Re: Help

panipat1990 — Thu, 10 Aug 2017 11:16:37 GMT

If i Select any MC LIKE 111010001 Then It Should be Show Sum(QTY) 909.

But in SUB_CAT_WISE Straight itr Should be show 7300.

Sum(QTY) Is same Both of table

Re: Help

panipat1990 — Thu, 10 Aug 2017 11:55:22 GMT

Dear Team,

I made two table.

MC_Wise Sum(QTY) Sub_Cat_Wise Sum(QTY)

111010001 909 1110100 7300

If i Select MC_CD THEN IT IS OK For MC_CODE_WISE_TABLE

But In Sub_CAT TABLE IT SHOW THE That Sub_CAT_CD_WISE SUM(QTY) Above i Gave Example

Re: Help

Kushal_Chawda — Thu, 10 Aug 2017 12:19:55 GMT

Data:

LOAD MC_CD,

SUB_CAT_CD,

QTY

FROM

[Data.xlsx]

(ooxml, embedded labels, table is FINAL);

Left Join

LOAD SUB_CAT_CD,

sum(QTY) as QTYNEW

Resident Data

Group by SUB_CAT_CD;

Create 1 straight table

Dimension:

MC_CD

Expression:

sum(QTY)

Straight table 2

Dimension:

SUB_CAT_CD

Expression:

sum(QTYNEW)

Re: Help

effinty2112 — Thu, 10 Aug 2017 12:32:38 GMT

Hi Gourav,

what about:

MC_CD	sum(QTY)	SUB_CAT_CD	sum(QTY)
111010001	909	1110100	7300
111010002	910	1110100	7300
111010003	911	1110100	7300

The last column is this expression:

Aggr(NODISTINCT sum({$<SUB_CAT_CD = p({<MC_CD = {$(=concat(MC_CD,','))}>}),MC_CD>}QTY),SUB_CAT_CD)

Cheers

Andrew

Re: Help

effinty2112 — Thu, 10 Aug 2017 12:35:11 GMT

Hi Gourav,

This selection of MC_CD shows the table's functionality better:

MC_CD	sum(QTY)	SUB_CAT_CD	sum(QTY)
111010110	919	1110101	4570
111010111	920	1110101	4570
111010201	132	1110102	3711
111010202	133	1110102	3711

Re: Help

Kushal_Chawda — Thu, 10 Aug 2017 12:42:59 GMT

I would suggest not to use the complex expression as you can easily group the data in script. Which will make the front expression easy

Data:

LOAD MC_CD,

SUB_CAT_CD,

QTY

FROM

[Data.xlsx]

(ooxml, embedded labels, table is FINAL);

Left Join

LOAD SUB_CAT_CD,

sum(QTY) as QTYNEW

Resident Data

Group by SUB_CAT_CD;

Create the straight table like below

Re: Help

panipat1990 — Thu, 10 Aug 2017 12:44:39 GMT

Kindly Send me QVW