Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

exclude selection in bar chart

IDTransportation
ACar
ABike
ABus
ACycle
AShip
BCar
BBus
BAirplane
CCar
CBus
CAirplane
CShip
DCycle
DCar
DHelicopter
DBoat

when I click B from ID list box

its related Transportation is Car,  Bus, Airplane

but business user need bar chart like

A=2 (because it have Car and Bus)

C=3 (because it have Car, Bus, Airplane)

D=1  (because it have CarBus)

Note:

I can't use Cross Table for this because it affect Data model

1 Solution

Accepted Solutions
Highlighted

May be this (using shankarece‌'s attached sample)

Count({<ID = E(ID), Transportation = P(Transportation)>}Transportation)

Capture.PNG

View solution in original post

3 Replies
Highlighted
Master II
Master II

Find the attached application. Do you want something like this?

Highlighted

May be this (using shankarece‌'s attached sample)

Count({<ID = E(ID), Transportation = P(Transportation)>}Transportation)

Capture.PNG

View solution in original post

Highlighted
Creator
Creator

u always awesome

Thank You Sunny.......