topic Re: Data manipulation in QlikView

Data manipulation

priyarane — Wed, 01 Nov 2017 09:52:42 GMT

hi Community,

Need help on below requirement.

I have data for ex:

Consol_Ent,Valu

HT,10

HB,20

HC,1

HD,2

HE,3

With above data I have to show another filter on dashboard.

if user select for Consol_Ent = HT, then we have to show anothe filter and data like

Det_Entity

now data shoulb be like after HT from Consol_Ent selection

HB 10

HD 2

-Priya

Re: Data manipulation

vishsaggi — Wed, 01 Nov 2017 13:35:56 GMT

Where you want to show this data? Where is the field Det_Entity? How is this field linked to your first table? Can you provide some more information please with more data?

Re: Data manipulation

Anonymous — Wed, 01 Nov 2017 13:36:51 GMT

So if a user selects "HT" from Consol_Ent then you would like to display data from "HB" and "HD"

User Selection "HT"

Result:

HB 20

HD 2

Are there any other cases like this if so how many.

Re: Data manipulation

priyarane — Wed, 01 Nov 2017 13:41:11 GMT

THERE ARE 2 DIFFERENT REPORTS AND ON ONE IT CONSOL_ENT AND ON OTHER IT IS DET_ENTITY...

Re: Data manipulation

vishsaggi — Wed, 01 Nov 2017 14:51:44 GMT

Can you share a sample app to look into? Still did not get you. May be you want to try like a trigger in your report. IF you can share some screenshots of what you are expecting to see that would help faster.

Re: Data manipulation

madhumitha — Wed, 01 Nov 2017 15:05:22 GMT

Hi Priya,

Could you please share some sample?