topic Re: Straight Table in QlikView

Straight Table

_rohitgharat — Mon, 24 Jul 2017 09:36:02 GMT

Hi All,

I have a following requirement:

Suppose in the straight table having following attributes:

Zone	State	City	Headcount
West	Maharashtra	Pune	30
West	Maharashtra	Nashik	20

If user clicks on headcount 30 a separate table should appear having all the information related to those 30 employees. and same for 20 also.

Can anyone help me with this??

Thanks in advance.

Regards,

Rohit

Re: Straight Table

Anil_Babu_Samineni — Mon, 24 Jul 2017 09:47:12 GMT

I don't think so whether it is possible, Can we know why we need this? Always i learn from marcowedel‌

Re: Straight Table

mangalsk — Mon, 24 Jul 2017 09:52:48 GMT

It is not possible but you can give 1 button as details on click of this redirect to sheet having detailed information

Re: Straight Table

Kushal_Chawda — Mon, 24 Jul 2017 10:00:00 GMT

Create another straight table

Dimension:

Zone ,State,City, EmployeeID

Expression:

Write Head Cout Expression

When you select any number from original table, it selects the associated dimension in that table, so in another table go to properties ->Layout-> In conditional put below expression

=if(getselectedcount(Zone)>0 and getselectedcount(State)>0 and getselectedcount(City)>0,1,0)

Re: Straight Table

techvarun — Mon, 24 Jul 2017 10:10:11 GMT

It is possible using

Fixed Straight table

Invisible(Transparent) Buttons

Toggling between filters and Charts using Variables etc

But definitely not a suggested design since redesign is almost not possible and managing the dashboard layout is very tough

Re: Straight Table

Anil_Babu_Samineni — Mon, 24 Jul 2017 10:13:44 GMT

But, his intention to hit over expression not in Dimension, May be?

Re: Straight Table

Anil_Babu_Samineni — Mon, 24 Jul 2017 10:14:24 GMT

This is not good idea as i assume, What if you have around 1L rows in straight object ??

Re: Straight Table

neha_shirsath — Mon, 24 Jul 2017 10:17:53 GMT

Hi,

Might be this is not possible but you can do something like adhoc report where you can give user list of dimension to choose details for Headcount.

Thanks,

Neha

Re: Straight Table

Nagaraju_KCS — Mon, 24 Jul 2017 10:19:56 GMT

I don't think so possibility in Straight table.

you can achieve in Pivot table.

Dimensions: Zone, state, City (City drag to up)

Measure: Count(HeadCount)

If you select Nasik or Pune. that should work.

in your detail report write this condition in Layout tab

Conditionla Property: GetSelectedCount(City)) >=1,0,1

hope it helps....

Re: Straight Table

effinty2112 — Mon, 24 Jul 2017 10:20:19 GMT

Hi rohit,

Have you considered a table with a calculation condition of

Count(DISTINCT City) =1

Re: Straight Table

PrashantSangle — Mon, 24 Jul 2017 10:24:36 GMT

But when you hit expression column it will automatically select regarding dimension value.

So logic suggested by kush141087 will work.

Regards,

Re: Straight Table

Anil_Babu_Samineni — Mon, 24 Jul 2017 10:27:41 GMT

Make sense I may missed this? Let me play around