topic Re: requirement in QlikView

requirement

Anonymous — Fri, 17 Nov 2017 11:11:59 GMT

there is one graph where am showing 2 calculated dimensions :

so the first condition says :

getselectedcount(field 1)=0

second condition says:

getselectedcount(field 2)>=0 and getselectedcount(field 1)=0

so now what i want is :

one of the data values in the dimension ,

so if i click on that it shud display me other values wrt to that ,

how to do it ,

Re: requirement

Anonymous — Mon, 20 Nov 2017 07:51:42 GMT

can anyone help regarding the same

attached is the sample,

so if i click on 2010 it shud drill down to other related values and for all the other dimension values(2009,2010etc) it shud drill down to one common dimension

Re: requirement

PrashantSangle — Mon, 20 Nov 2017 07:53:44 GMT

explain in detail.

Regards,

Re: requirement

Anonymous — Mon, 20 Nov 2017 08:04:00 GMT

attached is the screenshot

so for all the dimension values is hud drill down to one other field

except for 2010

Re: requirement

Anonymous — Mon, 20 Nov 2017 10:02:07 GMT

can anyone please help regarding the above mentioned query.

Re: requirement

Anil_Babu_Samineni — Mon, 20 Nov 2017 10:04:16 GMT

Question really not a quiet enough. Can you explain little more

Re: requirement

Anonymous — Mon, 20 Nov 2017 10:23:58 GMT

i basically just want to drill down ,if i select on any of the dimension values

Re: requirement

Anil_Babu_Samineni — Mon, 20 Nov 2017 11:22:30 GMT

To where you need to drilldown?

Re: requirement

Anonymous — Mon, 20 Nov 2017 12:13:25 GMT

in the dimension itself

Re: requirement

Anil_Babu_Samineni — Mon, 20 Nov 2017 12:14:54 GMT

Create sample work file and share with us, That may useful

Re: requirement

Anonymous — Mon, 20 Nov 2017 13:10:26 GMT

so as attached is the file:

where u have two dimensions,

so if u select on any of the band values its drilling to dimension fuel

but what i want is when the band value is 7307,it should drill down to another dimension which is voltage

i hope am clear now

Re: requirement

Anonymous — Mon, 20 Nov 2017 13:11:14 GMT

yes i have attched qvw file,

please help regarding the same.

Re: requirement

Anil_Babu_Samineni — Mon, 20 Nov 2017 13:32:06 GMT

PFA

Re: requirement

Anonymous — Mon, 20 Nov 2017 13:39:40 GMT

thanks anil,

but this nt as desired output,

for all the dimesnison values it shud drill to fuel only except 7307

so when we click on 7307 it shud drill to voltage.

Re: requirement

Anil_Babu_Samineni — Mon, 20 Nov 2017 15:00:57 GMT

PFA

Re: requirement

Anonymous — Tue, 21 Nov 2017 07:04:21 GMT

hey anil,u missed the attachment

Re: requirement

Anil_Babu_Samineni — Tue, 21 Nov 2017 07:09:10 GMT

It's there

Re: requirement

Anonymous — Tue, 21 Nov 2017 07:33:05 GMT

thanks so much

Re: requirement

Anonymous — Tue, 28 Nov 2017 08:08:46 GMT

hi anil

further to the above attachment,

am trying to drill to the frther next level ,but its not happening as desired,

where exactly we need to write the condition,kindly help and guide.

Re: requirement

Anil_Babu_Samineni — Tue, 28 Nov 2017 08:20:19 GMT

If you look in the attachment of Group there i used Calculation field rather direct. So, you need to work and understand the business where i done

After that, You need to Qlik Community Tip: Marking Replies as Correct or Helpful