Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

priyarane
Valued Contributor

Data manipulation

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

HB

HD

now data shoulb be like after HT from Consol_Ent selection

HB 10

HD 2

-Priya

5 Replies
vishsaggi
Esteemed Contributor III

Re: Data manipulation

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?

aronwilliamson
Contributor

Re: Data manipulation

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.

priyarane
Valued Contributor

Re: Data manipulation

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

vishsaggi
Esteemed Contributor III

Re: Data manipulation

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.

madhumitha
Contributor

Re: Data manipulation

Hi Priya,

Could you please share some sample?