Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
smilingjohn
Specialist
Specialist

Association

Hi ALL,

I am using Text box to display the numbers ..i have total counts of ID's  300

and i have divided into 3types ..

High low and neutral

Now i get  3 diffreent text Object which displays different vales for High, Low and Neutral

below this iam using a starigth table which will give me the detailed information and this is working fine ..

but the problem is when i click on any of the Text object ( high, Low, Neutral ) the table chart will not filter the value ...How do i achive  this ..

If i slect either of the text box then tha table chart should display me the detailed information about those ID which are either High, Low or Neutral

Iam using this expression with test Object


High

=count({<Category={'High'}>}ID)


Low

=count({<Category={'Low'}>}ID)


Neutral

=count({<Category={'Neutral'}>}ID)


do i need to alter in the explression ?



Thanks in Advance

3 Replies
ramasaisaksoft

Hi John,

Solution 1:-

Give a List box for High, Low, Neutral.it will resolve your issue.


Solution 2:-

create 3 variables for High, Low, Neutral

and create 3 Straight tables for High, Low, Neutral  ,in the LAYOUT tab under show / condition of each table you need to write conditional show if(vhigh=1,1,0)...etc.

and create 1 more  straight table with conditional show (vhigh and vlow, and nauteral are zero0)

so it will show all are failed.



Solution 3 :

create 4 straight tables (High, Low, Neutral ,Default one) and put them into container object.

rahulpawarb
Specialist III
Specialist III

Hello John,

You can create a variable to capture click for each category by adding an action (set variable) and different expression for every category will be enabled based on latest click.

Please refer sample application attached herewith.

Hope this will be helpful.

Regards!

Rahul Pawar

stabben23
Partner - Master
Partner - Master

Hi John,

you could also add an Action in every textobject.

Action Select In Field, like this for High