topic Re: How to create a Drill With Costomize Dimension -Urgent in QlikView

How to create a Drill With Costomize Dimension -Urgent

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

Hi All i have Column Like

Filter, Action, VisitID.

In Action i Have Apartment_Types and Price Range Values

and in Filter i have filter value that customer selected for Apartment Types and Price Range .

Say Example ,

For Apartment associate data are like

[1],

[1,2,3]

["3",1,2,3,4,5]

and in Price Range say,

{"Max":1}

{"Max":"2500000","Min":"500000"}

I wan to Create a Bar Chart in that i want Drill say Example ..

Intially It will show Apartment types and Price range and Measures Will be Count( Distinct VisitID)

But When User Drill the Apartment Types he can See

Dimension as 1BHK ,2BHK,3BHK,4BHK,5BHK.

and Count of Selection as per user .. Means if Data is [1,2,3,4].. it gives count 1 for all BHK Except 5BHK and Like that..

and Second if User Drill Price Range

it shows Dimension 0-25L ,25-50L ,50-75L and more..

Means {"Max":"2500000","Min":"500000"} will Count 1 for 0-25L Price Ranage...

Kindly help me for the same

Re: How to create a Drill With Costomize Dimension -Urgent

brijeshvma — Fri, 18 Mar 2016 07:04:06 GMT

Hi All ,

I am not able to create any idea to come with the output .

Can u please suggest me any update on this

Re: How to create a Drill With Costomize Dimension -Urgent

amayuresh — Fri, 18 Mar 2016 09:26:32 GMT

This will help you to identify the BHK requirement.

Add below line in your script:

Output:

Re: How to create a Drill With Costomize Dimension -Urgent

brijeshvma — Fri, 18 Mar 2016 10:13:50 GMT

Hi Mayuresh ,

Thanks for ur reply...but I needed something different..

If should display 1BHK , 2 BHK and further...if input is

[1,2,3,4,5] ...is should it count 1 in All BHK...

Re: How to create a Drill With Costomize Dimension -Urgent

amayuresh — Fri, 18 Mar 2016 10:28:42 GMT

Please elaborate your requirement in details with example.

Re: How to create a Drill With Costomize Dimension -Urgent

brijeshvma — Fri, 18 Mar 2016 10:39:00 GMT

Hi,

Just check my qvw ..

first look I should bar chart as Action Dimension.

Values are Apartment types and Price range

If user drill the Apartment types .it should show..

1BHK ,2 BHK ,3 BHK , 4 BHK ,5 BHk...

When user go to website and check the filter for Apartment types and say he selected 1,2,3 BHK option

So we get data like [ 1,2,3]. It means in 1 BHK stack count will be 1 in 2 BHK stack will be 1 Count and same for 3...in ur solution it will show combined 1BHK2BHK3BHK stack...but it should show seperate

Re: How to create a Drill With Costomize Dimension -Urgent

amayuresh — Fri, 18 Mar 2016 11:30:01 GMT

Output:

Script : Use this line in script for separate BHK

Re: How to create a Drill With Costomize Dimension -Urgent

brijeshvma — Sat, 19 Mar 2016 20:42:25 GMT

Hi Mayuresh,

its not giving a Proper Answer..

if data is ["2",3,1] is showing 3 BHK ... But it should show 1 for 2 BHK , 3BHK , 1BHK..

Re: How to create a Drill With Costomize Dimension -Urgent

brijeshvma — Mon, 21 Mar 2016 09:15:31 GMT

Can anyone please suggest me on this as well

Re: How to create a Drill With Costomize Dimension -Urgent

brijeshvma — Mon, 21 Mar 2016 10:10:55 GMT

hi,

Can anyone please suggest me on this .

Re: How to create a Drill With Costomize Dimension -Urgent

brijeshvma — Mon, 21 Mar 2016 11:30:33 GMT

Hi,

Any one having any Suggestion on this.. that how to resolve this

Re: How to create a Drill With Costomize Dimension -Urgent

amayuresh — Mon, 21 Mar 2016 11:38:01 GMT

This is what I was showing in first proposal.

Suggestions,

Clarify your requirement and expected output in detail and clear. if possible provide screenshot.